I have an SSIS Package that is copying data from a column that is Nullable to a table where the same column is not Nullable. There is red tape involved in making the source not nullable so for now I need a way to change the nulls to empty strings. I get the data from an ADO .Net Source, not a query where I could just add a check for nu...
I have a table with a list of contract line items in the form of CREATE TABLE contracts_lines ( contract_id integer, product_id integer, contract_line_start datetime, contract_line_end datetime, amount float ) What I would like to produce is a VIEW (or populate a table) that allows me to determine how much revenue I can expe...
I have a data viewer attached to a transformation to show me the data as a grid. At the bottom is says total rows 22002, rows displayed 9964. How do I get it show me the remaining rows? I've tried clicking and right clicking on everything! ...
Getting this error trying to run an SSIS Package on a 64 bit install of SS2K5 Enterprise Edition SP3. Package was developed using 32 bit BIDS, and deployed successfully to 64 bit SS2K5 Enterprise Edition SP2, and 64 bit SS2K5 Developer Edition SP3. Have upgraded client tools to SP3 with same result. Amy ideas? ...
I am working on a custom data transformation component. I'm using NUnit and NMock2 to test as I code. Testing and getting the custom UI and other features right is a huge pain, in part because I can't find any documentation about the order in which SSIS invokes methods on the component at design time as well as runtime. I can correct t...
I have data which resembles the following: "D.STEIN","DS","01","ALTRES","TTTTTTFFTT" "D.STEIN","DS","01","APCASH","TTTTTTFFTT" "D.STEIN","DS","01","APINH","TTTTTTFFTT" "D.STEIN","DS","01","APINV","TTTTTTFFTT" "D.STEIN","DS","01","APMISC","TTTTTTFFTT" "D.STEIN","DS","01","APPCHK","TTTTTTFFTT" "D.STEIN","DS","01","APWLNK","TTTTTTFF...
How can we abort the table post in this event: public override void Input0_ProcessInputRow(Input0Buffer Row) ... based on an input table field condition in our SSIS Script Component? For example if(Row.BoolValue) AbortPost(); We don't want to abort the whole process just this one record post. This is one record from the input table...
What is the main purpose of Lookup Transformation Task ? ...
SQL Server 2008 provides the ability to script data as Insert statements using the Generate Scripts option in Management Studio. Is it possible to access the same functionality from within a SSIS package? Here's what I'm trying to accomplish... I have a scheduled job that nightly scripts out all the schema and data for a SQL Server ...
Hello! I'm looking for a tool or component that generates flat files given a SQL Server's query result (from a stored procedure or a SELECT * over a table or view). This will be a batch process which runs every day, and every day a new file is created. I could use SQL Server Integration Services (DTS), but I have a mandatory requiremen...
How come I cant maintain the files which I had added for Reference? Each time when I go for Edit Script, I have to add the file for Reference for resuming the coding. Is there any other settings for maintaining the files added for reference ? And I am not getting some of the methods like "Response" then namespace like System.Web.HttpRes...
I have a Product record that has multiple "zoned" prices, one for each store that sells the product. ProductID int Name string PriceA money PriceB money PriceC money In SQL Server Integration Services, I need to split this in to multiple records: ProductID int Version string // A, B, or C Price money // PriceA ...
Using Script Task, I have written a code to create a folder and create a file of msword document inside the created folder. Its working in local machine. But its not working in another server, after I deployed it. The folder is created successfully, but the word document file is not created. for word document creation, I had to refer ano...
Can you provide detailed overview of Script Task including Add reference of another assembly with deployment process in the case of referred assembly. ...
How do we store DataSet object to Dts variable of data type "Object" and store back to another Dataset object, in Script Task ? ...
Is it possible to execute a SSIS package in C# Code ? We can process cube using the namespace "Microsoft.AnalysisServices.AdomdClient". What will be namespace/method to be used for executing a package/task, if possible? This considers Script Task too, in SSIS. ...
Hi, I am fairly new to SSIS. I came across a situation where i have to use a data flow task. The data source is MS- SQL server 2008 and destination is Sharepoint list. I gave an SQl query for Data source object as SELECT Customer_ID, Project_ID, Project_Name, Project_Manager_ID, Project_Manager_Name, DeliveryManager1_ID, DM1NAME F...
I have an excel file. I wanted to pull the data from excel file to SQL Server table. And the data is successfully transferred.In the excel file, I removed a text from one column named "Risk" from one row.The text was lengthy one.now the package execution fails at the source ie from the excel file. The errors are shown as "[Audit [1]] E...
Hi, I am trying to use SSIS to import data from a XML file. One of the element in the XML file contains binary data of a pdf file. I created a SSIS package and setup the column properties of the XML source to DT_BYTES and also tried DT_IMAGE. But I get the following error. Error: 0xC0209029 at Data Flow Task, XML Source [1253]: SSIS Err...
Hi all, I need to convert the system datetime to timestamp in script task SSIS. input date format: 29/05/2010 2:36 AM output format: 29-15-2010 14:36:00 thanks prav ...