SQL Server 2005 Integration Services

• Topics

  Started by

  Posts

  Last post

• Error :t" property not set correctly, parameters not set correctly, or connection not established correctly.

  I have an SSIS job running in production.The job failed today with an error message Executed as use…

  Pink123

  3 replies

  12 years, 7 months ago

  By: herladygeekedness

• Move file from Network drive to a new Folder

  Hi, I have a task , in which I need to move a file from a Network drive to another location( loca…

  komal145

  3 replies

  12 years, 7 months ago

  By: Phil Parkin

• truncation error but data types are the same

  Afternoon all, I have a flat file .csv format that I am importing. It is 53 columns across and when…

  aazzner

  1 replies

  12 years, 7 months ago

  By: aazzner

• error in script component

  hi, iam getting following error in script component. TITLE: Package Validation Error --------------…

  harri.reddy

  2 replies

  12 years, 8 months ago

  By: harri.reddy

• derived column

  hi, this is my derived column expression , SUBSTRING([Column 0],FINDSTRING([Column 0],"PAT",1),FIND…

  harri.reddy

  2 replies

  12 years, 8 months ago

  By: Eugene Elutin

• HOW TO CONTINUE PROCESSING IN A FOR LOOP CONTAINER AFTER ERROR HAPPENDS

  ISSUE: HOW TO CONTINUE TO PROCESS THROUGH A SET OF VALUES USING A FOR LOOP CONTAINER WHEN THE CONTA…

  wnarretto

  2 replies

  12 years, 8 months ago

  By: Kranthi Babu

• SSIS with NOMAD Datasource

  I have been scouring the web for references to using SSIS to do ETL from a NOMAD database as the da…

  Ron Kunce

  2 replies

  12 years, 8 months ago

  By: D.P.

• derived column syntax error

  hi, i am using this expression substring([Column 0],findstring( [Column 0],"TH",1),findstring( [Col…

  harri.reddy

  2 replies

  12 years, 8 months ago

  By: harri.reddy

• split field using script

  hi, in my derived column i have 1 column like column1 = TH*4.0*375*01**20120521*190100*P*: now usin…

  harri.reddy

  1 replies

  12 years, 8 months ago

  By: Koen Verbeeck

• IS it possible to have dynamic sql in ole db src where the table is the part that is dynamic?

  I am trying to create a for each loop and inside the loop add a dataflow where I pass in a variable…

  dndaughtery

  3 replies

  12 years, 8 months ago

  By: dndaughtery

• time data type in ssis

  hi in my databse i have 1 field as time data type now when i create variable in ssis , i dont find …

  harri.reddy

  1 replies

  12 years, 8 months ago

  By: TangoVictor

• insert data from file to sql table

  hi i have flat file like this TH*4.2*876545*P~~IO*3456*color~ now i have two tables create table ta…

  harri.reddy

  8 replies

  12 years, 8 months ago

  By: harri.reddy

• How to compare current row with previous row

  I'm not sure how this can be done in SSIS, but I would like to compare the current row to the previ…

  bobd125

  7 replies

  12 years, 8 months ago

  By: Phil Parkin

• WMI EVENT WATCHER TASK STAYS YELLOW

  Hi, I have a WMI Event Watcher task with the below WQL Query. Then task stays yellow even when a fi…

  jyoti_bhatt

  2 replies

  12 years, 8 months ago

  By: eclispe66

• Progress To Sql Server

  Hi, I am using SSIS to transfer a Database from progress to Sql server. I am using OpenEdge 10.1B O…

  saillu78

  7 replies

  12 years, 8 months ago

  By: maretix