Hi All, I have a table with 24 columns of varchar(1000) and 1 column with varchar(8000), my source is of same data lengths of text files. Would I get any problems in the processing due to data lenghs in performance or over size of the sql limit page size. thanks prav ...
What is the best way of loading a fact table incrementally using SSIS? ...
I want to cast a date into ISO format, and use it as a string in an expression in SSIS. This is what I type in T-SQL select convert(varchar(8), GetDate(), 112) and this is what I get back 20100630 My goal - is to create an archive folder based on the date. I have the File System Task part of creating a folder sorted, I can do that...
Is there any way to initialize the value of two variables in the InitExpression of a For Loop Container in SSIS? For example: InitExpression: @BeginDate = (DT_DBTIMESTAMP) "1/1/1900"; @EndDate = (DT_DBTIMESTAMP) "1/1/2007" EvalExpression: @BeginDate < GETDATE() AssignExpression: @BeginDate = @EndDate; @EndDate = DATEADD("Month", 1,...
Hi all, I am getting the following error in the log of the SSIS "The output column "XXXXXXX" (624) on the non-error output has no corresponding output column on the error output". I did make sure that the column does exist in the database, also whent in to the Advanced Editor of the step (First time around I get "The Index is not valid" ...
I need to pull data from csv file to SQL Server table. Which Control task should I use ? Is it Flat File ? What is the correct method to pull data ? The problem is I have used Flat File Task for pulling csv file. But the csv file whihc I am having, contains headings as first row, then on the third row, I have the columns, and data start...
I need to migrate the DTS (SQL 2000) package into SQL 2008 SSIS. The DTS package is using HTML file data source and a Transformation task to import the HTML table into the SQL table. I didn't find the HTML data source in the Connection Manager in the SSIS designer. Does this functionality exist in the SSIS ? Thank you. ...
I have a package in SSIS, in the data flow I have a script component that is a data source, setting variables to an Excel Data Flow Destination. With ScriptOutputBuffer .AddRow() .scriptRowID = 2 .Filename = Variables.foundFile .RunTime = Now .Status = "found" End With Unfortunately the dates are coming out in the ...
I Have the c# code here. using Microsoft.SqlServer.Dts.Runtime; string filedts = "C:\\SSIS\\SQLtoFLAT\\PQFormTEST2.dtsx"; Application app = new Application(); Package package = app.LoadPackage(filedts, null); DTSExecResult result = package.Execute(); I see all website code is the same like this, but when I run it I in ASP.NET, ...
i went to: menu > tools >options > fonts and colors > business intelligence designers...but nothing happened when i changed the font size. i'm using visual studio 2008 what am i missing here? ...
Hello Am a newbie to to SSIS Custom Component. Just started to code a component where the input row count will never be same as output row count. foreach input row it does some validation and generates n rows which need to be mapped to output buffer. So after with Design time validation coding everything is fine. my RunTime code is ...
Hi All, I have a flat file source as SOURCE1~SOURCE2~SOURCE3 1~2~3 1~2~3 target is 1~2~3 1~2~3 which is normal case. now the scenario as my extract has changes to SOUCE2~SOURCE1~SOURCE3 1~2~3 1~2~3 now the target is still 1~2~3 1~2~3 but needs to get as 2~1~3 2~1~3 the data in the target table is not dynamically getti...
SQL Server : How do I put a label on top of "Data Flow" tab of my ssis package ? ...
Some modifications were made to an SSIS package and I can't seem to figure out what is wrong. The SQL server agent job which involves execution of one of these packages was running fine until a couple of days ago. The error I am seeing is this... Executed as user: domainname\serviceaccount. ... for 32-bit Copyright (C) Microsoft Cor...
I have a job created to run a SSIS package. I had problems with package security for a while, but managed to set the package password correctly and that error disappeared. This next error was not occurring last night, but today I can't seem to get rid of it. If I run the package independently via BIDS or by connecting to my Integratio...
I would like to know which one is the best approach for migrating existing DB data to another new DB with entirely different structure. I want to copy the data from my old DB and need to insert the data in new DB. For me the table names and column names of new DB is entirely different. I am using SQL Server 2008. ...
In an SSIS package I have a For..Each container that enumerates all (.) the files in a folder. In that For..Each container I have a component-level variable 'fileComments' of DataType 'String'. In that For..Each container I have a script task. With a ReadWrite entry for 'filecomments' (amongst others) In that script task, I have some ...
The debugging experience in SSIS is not what I am expecting. I have a script Task that I have added a Imports System.Diagnostics' at the header of the class, and in the code I have various debug.writeline ("Attemtpting to move file") type messages. But, they are not displaying in the output window. Am I missing something ? ...
I'm tring to create an SSIS package to import some dataset files, however given that I seem to be hitting a brick wall everytime I achieve a small part of the task I need to take a step back and perform a sanity check on what I'm trying to achieve, and if you good people can advise whether SSIS is the way to go about this then I woul...
I'm writing a SSRS report that is the direct result of a SSIS package. It is my understanding that SSIS must have exclusive access to Excel files for import. Is there any way around this? If I can't read what was there as of the last save, can I at least send an e-mail notifying the user of the failure? How do I catch that error? ...