SQL Server 2005 Integration Services

• Topics

  Started by

  Posts

  Last post

• increment numbers in sql

  i have a flat file that's has some numbers in it. eg 001 002 003 004. I have set it to int so I no …

  ronan.healy

  10 replies

  10 years, 8 months ago

  By: Eirikur Eiriksson

• CSV Import Problem

  Hi, This driving me nuts! I'm being sent a unicode CSV file that has some text qualifiers and is ki…

  GN-340682

  17 replies

  10 years, 8 months ago

  By: santosh.hungund

• Passing Argument from Execute Process Task (SSIS) to a Batch File

  Hello, I have a batch process set up, which executes fine as long as the name of the file is built …

  kissa49

  1 replies

  10 years, 8 months ago

  By: priyadarshini128

• BIDS working fine, SQL agent Job fails

  I am getting message from SQL Server Agent Job when i tried to submit the job. SSIS package is work…

  kshatriya24

  6 replies

  10 years, 8 months ago

  By: kshatriya24

• SSIS Derived Column, Expression Help

  How I can change this IP Address 14.192.128.0 To 014.192.128.000 Or how I can parse above IP in 4 …

  rocky_498

  2 replies

  10 years, 8 months ago

  By: Mohit Dhiman

• Flat File Destination

  hi i have been asked to add in a Flat File Destination box at different points in my package. is i…

  ronan.healy

  5 replies

  10 years, 8 months ago

  By: ronan.healy

• Execute SQL Task - Getting error calling Oracle Stored procedure

  I am trying to execute an Oracle stored procedure from within SSIS Execute SQL Task and am getting …

  mz1derful

  1 replies

  10 years, 8 months ago

  By: rakesh1084

• Argument "Excel" for option "connection" is not valid. The command line parameters are invali

  Hi , I get the error : " Microsoft (R) SQL Server Execute Package Utility Version 10.50.…

  komal145

  1 replies

  10 years, 9 months ago

  By: SQListic

• Having Job with 6 steps is failing at step3 and if it fails at step 3 it should goes and run from step1,2,3 bt if again if it fails at step3

  Hi all having Job with 6 steps is failing at step3 and if it fails at step 3 it should goes and run…

  naga.rohitkumar

  1 replies

  10 years, 9 months ago

  By: Koen Verbeeck

• date problem

  i have a date coming in like this 21/03/2018 I keep getting an error. do I have to convert it I tri…

  ronan.healy

  9 replies

  10 years, 9 months ago

  By: Koen Verbeeck

• Issue with Unicode Conversion

  I am using SSIS 2008. The package retrieve data from one source DB table and insert to other DB tab…

  RCRock

  7 replies

  10 years, 9 months ago

  By: Phil Parkin

• falt file connection

  Can an xlsx excel file be read in using a flat file connection. I tried a few different column deli…

  ronan.healy

  1 replies

  10 years, 9 months ago

  By: Phil Parkin

• Slowly Changing dimension inside a ForEach Loop container

  Hi there folks, Sorry for the lengthy topic but this is my first post - as you can tell! I am havin…

  romina

  27 replies

  10 years, 9 months ago

  By: romina

• Returning Values from a Stored Procedure (SQL TASK, SSIS)

  Hi all, Here the problem: I have the following stored procedure: [font="Courier New"] ALTER procedu…

  dave-dj

  7 replies

  10 years, 9 months ago

  By: rgagne99

• How do you move a package from a sql2005 Test Server to another SQL2005 Server

  Hi - I've built an Intergration Services package on a SQL2005 Test environment. I have run through …

  dax.latchford

  3 replies

  10 years, 9 months ago

  By: SQLRNNR