SQL Server 2005 Integration Services

• Topics

  Started by

  Posts

  Last post

• Inserting data into a Table with no Identity Column

  I am using a SSIS package to synchronise data between my data warehouse main tableset, and an appli…

  Paul_Harvey

  3 replies

  16 years, 2 months ago

  By: Jeff Moden

• SQLServer 2005 SSIS Replication Database with customized Tables & Columns

  Hi folks, I am a SSIS beginner and I am exploring SSIS right now for some projects. The logic is ve…

  princa

  20 replies

  16 years, 2 months ago

  By: Elliott Whitlow

• can I use SSIS to get xml documents from a directory and give it as an argument to a stored procedure

  can I use SSIS to get xml documents from a directory and give it as an argument to a stored procedu…

  Sarsoura

  1 replies

  16 years, 2 months ago

  By: Elliott Whitlow

• Add data column that doesn't exist in the dataset

  So, using T-SQL you can write a select query that adds a column of data to the results that doesn't…

  ImYourDBA

  8 replies

  16 years, 2 months ago

  By: Raunak Jhawar

• Data Mirgration Help

  Our department just purchased a large database system to replace an internal Access case management…

  mcmail30

  2 replies

  16 years, 2 months ago

  By: Phil Parkin

• OLE DB Source [1]] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E21. An OLE DB record is available. Source: "ASAProv.90" Hresult: 0x80004005 Description: "Cannot convert parameter 2 to a DBTYPE_STR".

  Cannot convert parameter 2 to a DBTYPE_STR" SSIS I am new to this SSIS Package please help me I am …

  karunakarraop

  1 replies

  16 years, 2 months ago

  By: Koen Verbeeck

• crc32 logic for hashvalue

  Hi, I want to implement the CRC32 logic for calculating HASH values in my script component. Help me…

  srinivasable

  2 replies

  16 years, 2 months ago

  By: COZYROC

• How to remove string from variable value?

  Hi, I created a variable with name 'source_file' with string data type and default value is 'C:\t…

  elchuru

  3 replies

  16 years, 2 months ago

  By: elchuru

• SSIS send mail task error out specified string not in form req for an email address

  My send mail task works fine for email ids like user@mydomain.com but it throws error for email ids…

  pramod.chavan

  4 replies

  16 years, 2 months ago

  By: pramod.chavan

• Import File Using SSIS FTP Task

  Is there a link or "walk through" that shows you how to set up a job to go to a web server, log on …

  Lonnie Johnson

  7 replies

  16 years, 2 months ago

  By: p c jain

• Problem with having mutiple script tasks in an SSIS Package

  I have a package with 3 control flow tasks all enclosed in a sequence container. For each of these …

  Joseph Cooper

  11 replies

  16 years, 2 months ago

  By: Joseph Cooper

• Import

  I had a dts package . When I run the package the data gets loaded into excel. The data gets importe…

  sql2k8

  6 replies

  16 years, 2 months ago

  By: sql2k8

• How to convert string datatype to datetime in Derived Column

  I am attaching the text file for reference in this context, i need to convert the string data type …

  snookala08

  11 replies

  16 years, 2 months ago

  By: Koen Verbeeck

• How to import permon log file (converting Date)

  I am creating logs via Perfmon on things like Page File Byte Peak, etc. and I'm having a bit of tro…

  ImYourDBA

  9 replies

  16 years, 2 months ago

  By: Phil Parkin

• Read Excel Cells from SSIS - how to load a complicated spreadsheet

  Hi All, I have a spreadsheet i would like to load to a sql server table but its not a straig…

  Patrick.I

  1 replies

  16 years, 2 months ago

  By: divyanth