Sunday, March 25, 2012
Bind a stored procedure within dataview
Wizard. But only SQL String are allowed.
How can I "put" my stored procedure in this data view ? (I try EXEC
my_stored_proc in the SQL String area but not working...)
I would like to do it because I have almost 60 fields to add one by one into
a table manualy
If one of you have tips or can help me, I will appreciate :)
Have a good day !Are you getting any particular Errors? I've found that some sproc can be
called using exec sprocname @.Param1,@.Parm2 etc., while some do not. I've
resorted to the follwowing:
Putting a select * from table1
Once you get to the data tab, click on the ... and change the Command Type
to stored procedure.
You can then enter you sproc name in the query string box (don't enter the
exec).
If the sproc has parameters you'l need to set those up as well, to feed the
sproc.
"JahPil" wrote:
> As I would like to execute a stored procedure within the Report Creation
> Wizard. But only SQL String are allowed.
> How can I "put" my stored procedure in this data view ? (I try EXEC
> my_stored_proc in the SQL String area but not working...)
> I would like to do it because I have almost 60 fields to add one by one into
> a table manualy
> If one of you have tips or can help me, I will appreciate :)
> Have a good day !
Monday, March 19, 2012
BIDS programming
Hi,
I want to create a wizard to help build my packages for certain situations, something like the export and import wizard.
I couldn't find the API to do it. can you help?
Thanks
Noa
Search Books Online for Integration Services Programming.
Lots o' content there.
K
|||Can you be more specific?
I only found programming custom components to SSIS, not a wizard to ease use.
|||SQL Server Books Online does not have documentation on programming your own Wizard application. I think that you'll find some information on this in the Visual Studio documentation.
As for creating a package programmatically -- which is what you want your wizard to do, as I understand -- you will find sections in BOL on "Building Packages Programmatically" and "Building the Data Flow Programmatically" to get you started.
We are all learners when it comes to the vast and flexible new Integration Services APIs.
-Doug
|||
Noa wrote:
Can you be more specific?
I only found programming custom components to SSIS, not a wizard to ease use.
You will need general VS documentation. See topics VsWizard Interface, IDTWizard Inteface.
Also there is a topic Walkthrough: Creating a Wizard in Dev Tools & Languages > VS > IDE > Customizing and Automating the Development Environment > Automation and Extensibility for Visual Studio > Creating Add-ins and Wizards.
BIDS programming
Hi,
I want to create a wizard to help build my packages for certain situations, something like the export and import wizard.
I couldn't find the API to do it. can you help?
Thanks
Noa
Search Books Online for Integration Services Programming.
Lots o' content there.
K
|||Can you be more specific?
I only found programming custom components to SSIS, not a wizard to ease use.
|||SQL Server Books Online does not have documentation on programming your own Wizard application. I think that you'll find some information on this in the Visual Studio documentation.
As for creating a package programmatically -- which is what you want your wizard to do, as I understand -- you will find sections in BOL on "Building Packages Programmatically" and "Building the Data Flow Programmatically" to get you started.
We are all learners when it comes to the vast and flexible new Integration Services APIs.
-Doug
|||
Noa wrote:
Can you be more specific?
I only found programming custom components to SSIS, not a wizard to ease use.
You will need general VS documentation. See topics VsWizard Interface, IDTWizard Inteface.
Also there is a topic Walkthrough: Creating a Wizard in Dev Tools & Languages > VS > IDE > Customizing and Automating the Development Environment > Automation and Extensibility for Visual Studio > Creating Add-ins and Wizards.
BIDS - How to turn-off auto naming of fields
Hi:
When I create a report, the wizard auto-renames fields.
E.g. if Table_COLUMN_Name=CustomerName, the list column header in the report will change to Customer Name. The wizard figures out Friendly names based on capitalization, and underscores and so on.
Similar behavior occurs even in SSAS projects Dimensions Wizard.
Is there a way to turn of this extra cuteness?
TIA
Kar
Hi:
Request help once again on this.
TIA
Kar
Sunday, March 11, 2012
BIDS - How to turn-off auto naming of fields
Hi:
When I create a report, the wizard auto-renames fields.
E.g. if Table_COLUMN_Name=CustomerName, the list column header in the report will change to Customer Name. The wizard figures out Friendly names based on capitalization, and underscores and so on.
Similar behavior occurs even in SSAS projects Dimensions Wizard.
Is there a way to turn of this extra cuteness?
TIA
Kar
Hi:
Request help once again on this.
TIA
Kar