SQL Server 2005 Integration Services

• Topics

  Started by

  Posts

  Last post

• Password error in SSIS

  Hi all, Trying to set up new SSIS packages on a SQL 2005 machine to replace all my DTS packages on …

  pete.olding

  5 replies

  9 years, 7 months ago

  By: ZenDada

• welcome error handling expets

  hi all experts, I created a SSIS package basically it's doing import process using excel connection…

  caojunhe24

  5 replies

  9 years, 7 months ago

  By: Sean Lange

• Script task hangs on execution

  hi, I have a script task that reads the variable named"result" ( the stored procedure is ran in ex…

  komal145

  1 replies

  9 years, 7 months ago

  By: Phil Parkin

• SSIS - Package Configurations - Store Client Certificate in SQL Server Table for HTTP Connection Manager -> CLIENT CERTIFICATE

  Dear All, Hi! I have a requirement to download Access file from HTTPS server using Client Certific…

  bharat sethi

  1 replies

  9 years, 7 months ago

  By: triparnaray

• SSIS excel source case sensitive fields

  Hi, I have an excel file and there are some columns that are different for each file. For example…

  PSB

  7 replies

  9 years, 8 months ago

  By: Ant-Green

• SSIS with SAP BW

  I am using a SSIS 2008 and MS Connector 1.1 to load data to SAP BW 7.3. I am facing 1 issue with it…

  dharmbir.kumar 17056

  1 replies

  9 years, 8 months ago

  By: sivaprasad.pidugu

• Sharepoint List Source Error -A possible reason might be you are trying to retrieve too many items at a time (Batch size)

  I am trying to get data from a Sharepoint List using the following CAML Query in SharePoint List So…

  LOOKUP_BI-756009

  9 replies

  9 years, 8 months ago

  By: navinprabu

• Execute a SSIS Package with xp_cmdshell

  I have a job that runs a SSIS package using this command line: "C:\Program Files (x86)\Microsoft SQ…

  lucazav

  6 replies

  9 years, 8 months ago

  By: Jeff Moden

• run .cmd file from SSIS but on another server (not a sql server)

  Hi - anyone got any thoughts on how to go about this. The other server is non sql - just a plain wi…

  allen davidson

  7 replies

  9 years, 8 months ago

  By: wangfuyee

• Excel File Data Import issue in SQL

  Hi All, I am facing a very weird issue. I have source Excel(.xlsx) file and SQL table Destination.…

  rocky_498

  2 replies

  9 years, 8 months ago

  By: rocky_498

• SSIS Standards

  I am looking for a standards document for SSIS. Is there one like that somewhere ? Please advise.

  anilkumar0902

  3 replies

  9 years, 8 months ago

  By: divpatel83

• Argument "Server1" for option "connection" is not valid. The command line parameters are invalid. The step failed.

  I have a SSIS package run fine in BID, but when run as a sql agent job, it failed at the error: Arg…

  w.w.

  10 replies

  9 years, 8 months ago

  By: Taranjit Singh-373811

• Extract number,Month name and year from file name

  Hi guys, Please help me with below c# script to extract number,three letter month and year from fil…

  p.shabbir

  5 replies

  9 years, 8 months ago

  By: michal.lisinski

• SSIS Package Execution with Forloop

  I'm trying to execute an SSIS package with a script task in Visual Basic 2010. I get the following …

  sowmyapasala5

  2 replies

  9 years, 8 months ago

  By: Elliott Whitlow

• How to convert YYYYMMDD to datetime using SSIS Data Conversion?

  I have many *.csv files with a column value of YYYYMMDD. I need to import the string YYYYMMDD to a…

  pickgoods

  20 replies

  9 years, 8 months ago

  By: Ken