Integration Services

• Topics

  Started by

  Posts

  Last post

• Trying SQL Server Import and Export Wizard

  Trying SQL Server Import and Export Wizard iam getting this error Error 0xc002f210: Preparation SQL…

  nazareena.sulthana

  1 replies

  14 years, 2 months ago

  By: Charmer

• pass database name through a variable?

  Hi, I have a query SELECT '1355' As JurisId, 'TRA' AS ModCode,ci.atoCitation AS ModIDRef, '…

  Charmer

  7 replies

  14 years, 2 months ago

  By: John Mitchell-245523

• ONE-TIME MIGRATION FROM ORACLE TO SQL SERVER.

  re: ONE-TIME MIGRATION FROM ORACLE TO SQL SERVER. I want to know the best way to migrate tables f…

  xpxj

  5 replies

  14 years, 2 months ago

  By: Vikas S. Rajput

• Limit the error rows redirected in a dataflow

  Hi, While loading data from a file, I am redirecting the error rows in the data flow to a log file.…

  venus.pvr

  1 replies

  14 years, 2 months ago

  By: Elliott Whitlow

• Foreign key constraint error

  Hi Friends, I have a data flow which is going to insert some rows in a table...A column in the…

  Charmer

  3 replies

  14 years, 2 months ago

  By: Johan Bijnens

• SSIS Table Difference Warning

  Hi all, i have a question about a package in SSIS, i have an "OLE DB Source", then a "Row Count", t…

  antinovato

  2 replies

  14 years, 2 months ago

  By: SQLRNNR

• Executing through XP_cmdshell

  Hi Friends , I am just trying to run the package using this T_SQL command line " exec xp_cmdsh…

  Charmer

  1 replies

  14 years, 2 months ago

  By: Elliott Whitlow

• Dynamic expression in Text file Connection works when executed alone, but not when executed with package

  I have a Foreach Loop Container that grabs today's system generated text file from a shared locatio…

  m2griffiths

  1 replies

  14 years, 2 months ago

  By: m2griffiths

• replace blank values with null

  I'm importing data from flat text file to sql db. There is some blank values in gender column in th…

  sqlfriend

  5 replies

  14 years, 2 months ago

  By: cbianchi

• OLE DB command error;the OLE DB adapter cannot convert between types "DB_CY and "DT_TIMESTAMP".

  i get this error when using the OLE DB Command it says it says "the OLE DB adapter cannot convert b…

  klineandking

  1 replies

  14 years, 2 months ago

  By: rgtft

• How to filter a extremely large table using a result set as filter?

  Hi. Please help.... Scenario: SSIS gets a table filtered by date from Server A. The result is writt…

  MrAkki

  10 replies

  14 years, 2 months ago

  By: sam.dahl

• Reading File's Path from a Variable.

  Please assist me in the following issue. I have a package that I have deployed on a remote server. …

  falcon00

  7 replies

  14 years, 2 months ago

  By: Koen Verbeeck

• ssis import from flat file , need also a column from a sql table

  I have a ssis package, in it I first import data from a flat file source, then convert some columns…

  sqlfriend

  4 replies

  14 years, 2 months ago

  By: sqlfriend

• Export to SSIS and maintain Drop down

  Hello All, In this i have two task to be done. I have to export data from a excel 2007 to Table…

  praneshram

  2 replies

  14 years, 2 months ago

  By: praneshram

• Export to SSIS and maintain Drop down

  Hello All, In this i have two task to be done. I have to export data from a excel 2007 to Table…

  praneshram

  1 replies

  14 years, 2 months ago

  By: SQLRNNR