SQL Server 2005 Integration Services

• Topics

  Started by

  Posts

  Last post

• Need wildcards in File.exists() HELP

  I have a package that needs altering. What I have are files that I am moving to a different server…

  mgchris

  10 replies

  15 years, 7 months ago

  By: mgchris

• Call another ssis package from one ssis package

  How do we call one ssis package from another ? The second package has a parameter FileID to be pas…

  PSB

  2 replies

  15 years, 7 months ago

  By: Elliott Whitlow

• Please send me Interview Q &A

  can any one tell some interview questions in DBA & Developer

  sankarkot2007

  14 replies

  15 years, 7 months ago

  By: Raunak Jhawar

• SSIS - If Condition is Met, Send Email

  Hi, How can I use SSIS to send an email is a condition is met? For example, if I do a count and if …

  EjSQLme

  7 replies

  15 years, 7 months ago

  By: EjSQLme

• EXCEL 2007 files

  I am using excel 2007 files dynamically from ole db source in ssis 2005. I am using the following c…

  PSB

  3 replies

  15 years, 7 months ago

  By: tmitchelar

• Unsupported data type on parameter binding 0

  OK so here goes, First off I am in no way a programmer or a SQL guru. I have been working on a DTS …

  aziermann

  3 replies

  15 years, 7 months ago

  By: aziermann

• Double precision float DT_R8 column error

  Hi, I have a double precision float column named Fax from an excel 20077 source and its of type DT…

  PSB

  6 replies

  15 years, 7 months ago

  By: PSB

• Problem:: SSIS: Excel Destination. Mapping columns dynamically

  Hi My requirement is as follows: I have multiple Excel sheets in a folder which are in same format.…

  cooldudedeepu

  1 replies

  15 years, 7 months ago

  By: steveb.

• SSIS /DTS / ENTERPRISE SCHEDULE CAPABILITY

  hI, Please help me about this problem,, 1) Does the SSIS can handel files such as VMS files from…

  reymon26

  2 replies

  15 years, 7 months ago

  By: Steve Jones - SSC Editor

• Call SSRS from SSIS using script task

  How do we call ssrs report from ssis and email the report as excel to the recipients ? Thanks,

  PSB

  1 replies

  15 years, 8 months ago

  By: COZYROC

• Access date (DT_DATE) to SQL (datetime)

  Hy! I got an access-DB and i tried to push the whole data threw an SSIS-Package to a SQL-Server. Th…

  leetest

  1 replies

  15 years, 8 months ago

  By: leetest

• Export data from a select number of table in one sql database to another

  Hi there, I'm quite new at ssis so please bare with me if i make any mistakes or miss the obvious. …

  Schadenfreude-Mei

  1 replies

  15 years, 8 months ago

  By: Chrissy321

• Adding custom .dll task to the toolbox

  I have inherited a custom task in Dataflow. And all i got is a dll file. I copied that to the micro…

  Hunting SSIS

  1 replies

  15 years, 8 months ago

  By: Hunting SSIS

• Convert date to "YYYYMM" in ssis package

  We are pulling data from oracle and loading in to SQL server One column is report_time which is lik…

  chinni-652949

  8 replies

  15 years, 8 months ago

  By: chinni-652949

• How to Use package variable in Execute SQL task

  hi All, I want to use the variable in Execute sql task. My script will return based on the Variable…

  Pulivarthi Sasidhar

  2 replies

  15 years, 8 months ago

  By: Pulivarthi Sasidhar