Integration Services

• Topics

  Started by

  Posts

  Last post

• Transfer the Flat file to Success and Failure folder based upon the status

  I am importing a text file into SQL Server . 1. First I want to capture the txt filename and filepa…

  ASHISH.MEHROTRA 24522

  1 replies

  14 years, 4 months ago

  By: John Mitchell-245523

• How to dump XML files to SQL Server using Script Task?

  Hi – I have come across with an issue in my project where source is XML files stay in some remote s…

  MSBI Learner

  4 replies

  14 years, 4 months ago

  By: MSBI Learner

• SSIS SQL task calling stored procedure - need warning message

  Hi all, I have a SSIS task executing a SQL stored procedure. The sproc has a condition that should…

  Sha_

  5 replies

  14 years, 4 months ago

  By: Sha_

• SSIS Flat File Import .. If 0.00.. then apply condition

  Hi All, I am building an SSIS package where I import a text file and want to apply some conditions …

  aarionsql

  3 replies

  14 years, 4 months ago

  By: Koen Verbeeck

• missing records on output

  Hi forum, I am creating a fact table with various tables and is not giving all records that i am su…

  manuelroman98

  2 replies

  14 years, 4 months ago

  By: manuelroman98

• Migrating oracledata to sql server

  Need to migrate the oracle data (objects) to sqlserver using SSIS.. could any one tell me the step …

  geetha@in

  2 replies

  14 years, 4 months ago

  By: Gail Shaw

• Migrating oracledata to sql server

  Need to migrate the oracle data (objects) to sqlserver using SSIS.. could any one tell me the step …

  geetha@in

  1 replies

  14 years, 4 months ago

  By: Lowell

• SSIS 2008R2 - Data Quality

  OK, so I have a flat file. I have set all the columns in the flat file connection to Varchar (a lo…

  Ells

  4 replies

  14 years, 4 months ago

  By: Ells

• SSIS package runs successfully, but no records imported

  I have a data flow task that imports records from textfile to a sql table. It shows green successf…

  sqlfriend

  3 replies

  14 years, 4 months ago

  By: Elliott Whitlow

• Treating an xml file with multiple levels as a simple single record (of type xml)

  Hi all, Need some pointers on the following... I have a fairly complex xml file that will be my dat…

  chris_hurley

  3 replies

  14 years, 4 months ago

  By: GSquared

• How to run foreach loop container one loop only?

  Hi. I have an XML with 3000 records that go to table SalesVolumeHeader and SalesVolumeDetails using…

  mikko.carlos

  6 replies

  14 years, 4 months ago

  By: mikko.carlos

• How to divide one column data into different columns data in excel file

  Hi This is venkat I am in ssis Any one solve this problem i have one excel file all data in one col…

  venkat113

  1 replies

  14 years, 4 months ago

  By: chris_hurley

• SSIS SCENARIO

  Hi, this is the scenario i am trying can anyone help on this(its urgent) 204.243.130.5 - - […

  maheshkrishnas

  5 replies

  14 years, 4 months ago

  By: Koen Verbeeck

• READ INSIDE A FLAT FILE

  Hi ALL, I AM NEW IN SQL SERVER INTEGRATION SERVICES, I WOULD LIKE DOING SOME TRANSFORMATION INSIDE …

  by-my-self

  1 replies

  14 years, 4 months ago

  By: Koen Verbeeck

• Unable to find package after creating it in the visual studio

  hi freinds, I have creaed a package in visual studio 2005 but cannot see it in the msdb or in file …

  msalmaan

  1 replies

  14 years, 4 months ago

  By: Koen Verbeeck