Integration Services

• Topics

  Started by

  Posts

  Last post

• Dynamic Flat File Connection

  Hello, I´m using ssis 2005 and, i would like to read a table in sql server 2005 that contains the p…

  hugoscp

  5 replies

  15 years, 11 months ago

  By: Koen Verbeeck

• SSIS in multi domain network

  Guys & Gals I have an SSIS package that is gathering files from a number of servers within a s…

  JMartin-392745

  2 replies

  15 years, 11 months ago

  By: JMartin-392745

• Package runs after restarting the IIS

  I have a package that needs to be called from the asp.net page on button click. I deployed the pack…

  anuhya.mudumba

  1 replies

  15 years, 11 months ago

  By: Elliott Whitlow

• SSIS Script Component - Cannot implicitly convert type 'string' to 'string[]'

  Hi I'm trying to connect to a web service using the SSIS script component. The VB proxy for the we…

  pYak

  3 replies

  15 years, 11 months ago

  By: Elliott Whitlow

• Difference between SSIS Packages manually launched and Scheduled

  Hello I have some difficulties to retrieve data from AS 400 Tables to my SQL Server 2005 database (…

  guennal

  3 replies

  15 years, 11 months ago

  By: TangoVictor

• SSIS Script Component(transformation) to call SQL command and add result to Data flow

  I am rying to call a SQL expression that will return a value +1 and update the table value, then ad…

  mwomersleycarter

  7 replies

  15 years, 11 months ago

  By: mwomersleycarter

• Excute SQL Task and exporting results to variables

  Hello, I'm trying to use an Execute SQL Task and use the results to set variables. Scenario: Table…

  jmhanks1373

  5 replies

  15 years, 11 months ago

  By: jmhanks1373

• Split Excel data into SQL Server Table

  Hi there I have a column C1 in Excel which contains data as follows: C1 ------ 111-222-3333 mark@cl…

  Sy-1148362

  1 replies

  15 years, 12 months ago

  By: Koen Verbeeck

• SSIS Tutorials

  Hi ... i am learning SSIs myself only.I want some tutorials for practice. if anybody is having exam…

  vasanti mestri

  2 replies

  15 years, 12 months ago

  By: vasanti mestri

• string to date conversion using script component/data conversion transformation

  Hi All, I am in need of converting string( Eg: "Jun 20 2005 4.00 PM" --- this string is strored in …

  ramyaganesh11

  2 replies

  15 years, 12 months ago

  By: ramyaganesh11

• How to run a package within BIDS from a certain point in the package

  I've written a package but need to test it in BIDS. The first x tasks take a long time to run. Is t…

  Griffster

  3 replies

  15 years, 12 months ago

  By: steveb.

• Switching Exec Pkg Task from file to SQL in a config

  I have been developing a package that calls other packages and for development I use file connectio…

  TangoVictor

  1 replies

  15 years, 12 months ago

  By: Elliott Whitlow

• Execute sql task and variable

  i am trying to get list of records for a Ano and the query in my execute sql task is select Aname …

  keywestfl9

  1 replies

  15 years, 12 months ago

  By: TangoVictor

• Excel Connection manager

  I have an excel file with 3 blank rows. The data starts from the 4th row only. Is there a way I can…

  ns.sharath

  11 replies

  15 years, 12 months ago

  By: Adtjob

• Running a package as a job from Asp.net page

  Hi All, I have an Asp.net application which allows the user to upload data into the sql table using…

  anuhya.mudumba

  4 replies

  16 years ago

  By: anuhya.mudumba