Integration Services

• Topics

  Started by

  Posts

  Last post

• 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, 5 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, 5 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, 5 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, 5 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, 5 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, 5 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, 5 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, 5 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, 5 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, 5 months ago

  By: Phil Parkin

• Trouble Configuring Agent Job to Run SSIS Packages

  I'm very new to SSIS and I'm using the SSISDB catalog.  I've built some packages to move data …

  lmarkum

  1 replies

  7 years, 5 months ago

  By: Phil Parkin

• SSIS Error loading Excel file to table

  Hi I'm trying to create a data flow task which brings data from Excel File to SQL table. I'm doing …

  swathi9.sql

  1 replies

  7 years, 5 months ago

  By: sgmunson

• Send email on duplicates In SSIS

  Hi , I have a SSIS pacakge , which runs the Storedprocedure and results to Csv file and then l…

  komal145

  1 replies

  7 years, 5 months ago

  By: sgmunson

• Help in getting SSIS to load a Data Partition

  Hello, I have created a 1200 Version (2016) tabular cube. And in that cube I have create a number o…

  quinn.jay

  7 replies

  7 years, 5 months ago

  By: quinn.jay

• Mismatch or data overflow on MySQL Link Server

  I try to Insert some records to my remote MySql from my SQL Server.The MySql is connected as Link s…

  makis_best

  12 replies

  7 years, 6 months ago

  By: makis_best