Integration Services

• Topics

  Started by

  Posts

  Last post

• Error: The type of the value being assigned to variable "User::VARName" differs from the current variable type.

  BIDS 2008.  I need to create a bunch of text files inside ForEach loop in SSIS Package. 1 file…

  VoldemarG

  6 replies

  7 years, 6 months ago

  By: Phil Parkin

• Passing the Next Step Name to a Variable in SSIS

  I am trying to pass the name of the next step to variable the current step.For Example, I want to p…

  ben eiden

  3 replies

  7 years, 7 months ago

  By: Phil Parkin

• SSIS Execute SQL task Error An error occurred while assigning a value to variable

  I am running this statement on execute SQl task  /* drop function if exists */IF object_id(N'm…

  mnr123

  1 replies

  7 years, 7 months ago

  By: Phil Parkin

• ssis 2016 import issue

  In a new ssis 2016 server package, I am trying to update a sql server 2016 table with data from an …

  wendy elizabeth

  1 replies

  7 years, 7 months ago

  By: Phil Parkin

• SSIS package execution fails when trying to load large size Excel file via SSIS Catalog (SSISDB)

  Hello,I was working on a SSIS Package which simply loads an excel file into a SQL table without any…

  pmaceke

  5 replies

  7 years, 7 months ago

  By: Phil Parkin

• script task to read (direct file io) the first line of the file prior to the dataflow - if headers are invalid fail the package and do not process the load.

  I need script task to read (direct file io) the first line of the file prior to the dataflow - if h…

  saptek9

  1 replies

  7 years, 7 months ago

  By: Phil Parkin

• Cannot find where SSIS Package is executing SendMail task from

  BIDS 2008.  I need to apply a few modifications to an old SSIS Package. While executing packag…

  VoldemarG

  2 replies

  7 years, 7 months ago

  By: VoldemarG

• SSIS is not throwing error. dataflow task accepting the data into target table even source file has different column name

  In SSIS i have dataflow task which transforming data from flatfile to SQL table. But sometime flatf…

  saptek9

  2 replies

  7 years, 7 months ago

  By: saptek9

• recover the number of files processed by a Foreach loop

  Hello everyoneWho has an idea please how can I get the number of files processed by a loop foreachI…

  joujousagem2006 1602

  4 replies

  7 years, 7 months ago

  By: Phil Parkin

• SQL 2016 Integration Services on Win2016 Servers - Access is denied message when connecting (for administrator)

  I'm installing SQL 2016 Integration Services on Win2016 Servers.  I get the below error when c…

  jsqldba

  5 replies

  7 years, 7 months ago

  By: jsqldba

• Possible to Run SQL Task and Data Task Flow in Parallel

  Hello, I have three steps, that are the same as one another just a different table of focus, a Dele…

  quinn.jay

  1 replies

  7 years, 7 months ago

  By: Phil Parkin

• Importing XML Files into a flat table

  I'm working on a process to import XML files into flat table using SSIS.  I've been trying to …

  Luke L

  11 replies

  7 years, 7 months ago

  By: Jeff Moden

• Typcial Fastest Connection Manager to use through Drivers/Attunity wrapper for Data Export

  Is it OLEDB, ADO.NET or some other method of moving a flat file and bulk load?

  quinn.jay

  1 replies

  7 years, 7 months ago

  By: frederico_fonseca

• Data flow stops reading rows before it reaches the end of the input file

  I'm running SSIS on 2012. I have over 3 million rows in the source flat file but my dataflow is onl…

  vicki.l.lucht

  3 replies

  7 years, 7 months ago

  By: Matt Miller (4)

• How to run Deployed Pkg's at 64 bit

  Hello, I'm on a single SQL Server instance and box where both Dev and prod occur. I have VS 2015 in…

  quinn.jay

  8 replies

  7 years, 7 months ago

  By: Phil Parkin