SSIS

SQL Server 2008 SISS error row handling

Struggling with SISS I have data source and data destination With some bad data, I can't figure out how to set up sending the bad row to another destination There are over 50 columns. Sorce is a tab delimited text file Desitnation is SQL Table

SQL SERVEUR 2005 SISS AND WHERE statement

I create a SSIS to transfer the date from AS/400 TO SQL Server 2005, and it's work fine. when I go to modify it and I add a where statement to choose only the year 2008, I received the following error code 0x80131937

ExcelSource file - metadata validation

I need some assistance. I am using an excel file to import data to SQL tables. The problem I am running into is having to replace the metadata of the output columns with the metadata of the external columns. I do not want to do this manually everytime. [The metadata of the following output...

MaximumErrorCount

HOW DO I CHANGE THE MaximumErrorCount IN SSIS

SSIS package using dynamic configurations

Hi I have to create a package which process the analysis services cube and its partitions,and dimensions. This package should run every 15 minutes to process the cube. I have a procedure which creates the database in analysis services db and relational db for the current month. I have another...

Database refresh

i want to refresh the database for every week from a cluster environment. could you please suggest a feasible option not back and recovery. I tried the following ways: 1. through SSIS database transfer task-but it failed 2. through copy database wizard-not working please tell us how to work...

SSIS - Bulk Inserts dynamically into various tables depending on the input file name.

I have a scenario where a folder consists of various files with the format 'ABC_DbName_Date_TableName.txt' and there are many Databases with DBNames For e.g. - DB1, DB2 DB3 etc consisting of tables created every day with a 'Date_TableName' format. I need to provide a prompt to accept a folder name...

How to create a temporary table in sql 2005 via SSIS

I need to load a flat file into a temporary table. So I need to know how to step by step how to in SSIS "Data Flow Task" create a temporary table, load one col from the flat file to the temporary table along with the date it was loaded. I will then use the temporary table to delete from another...

SSIS package failure message

I am running SQL Server 2005 and my package fails with the following error: OnError MyServer\serverAD My_Object{F63BA2F3-E28F-4142-98D8-0E631F8D0D3A} {31AB7571-ECB2-4591-BFE1-CC8D59739230} Data conversion failed while converting column "Some_Column" (5017) to column...

Move data in SSIS via store procedure

How do I set up an SSIS pkg to move results from a stored procedure from an external ss2005 db to the local ss2005db?

How to sent SQLMAIL in SQL Server 2005, through SSIS job, when my particular field is updated in database, can we sent SMS also through the SSIS script.

How to sent SQLMAIL in SQL Server 2005, through SSIS job, when my particular field is updated in database, can we sent SMS also through the SSIS script.

Assigning access to SQL Server Integration Services (SSIS) packages

How do we assign access for users to SQL Server Integration Services (SSIS) packages?

Error messages in Business Intelligence Development Studio on SQL Server Integration Sevices

I am new to SQL Server Integration Services (SSIS). When I went into Business Intelligence Development Studio (BIDS) and tried to create a new project, I received this error message: "Could not load or assembly 'Microsoft.DataTransformationServices.Wizards' or one of its dependencies. The system...

Migrating data from Oracle 9i Database to SQL Server 2005

I would like to migrate the data from all used-defined tables in Oracle 9i Database to SQL Server 2005. I know of options like Linked Server, SSIS, SSMA for Oracle and BCP. Which amongst these is the best way to achieve data migration?

Problem with SSIS & AS400, Source is AS400, Dest is SQL2005

When I'm trying to retrieve data from AS400, I received the below error: The column status returned was: "Text was truncated or one or more characters had no match in the target code page.". How do I know which code page to use besides the default of 1252?

how to update a remote sql server2005 database on webserver with multiple similar local database on windows server 2003

Hello, I am developing an application which has several local windows server 2003. All the servers are having sql server 2005 database exactly similar structure but different datas. I want to keep a remote webserver server having a similar database updated online from all these local...

having problem with SSIS package

i have created the SSIS package from sql server Server management and its work fine but the problem I’m having, when I try to run it from SQL Server Management jobs. Every time when train it from Sql jobs it failed. Please advice on ….

How to Modify SSIS packages created by Copy Database Wizard in SQL Server 2005

Hello, I recently read Jeremy Kadlec great article titled, "Step-by-Step Guide: Migrating to SQL Server 2005 with Copy Database Wizard" at http://searchsqlserver.techtarget.com/generic/0,295582,sid87_gci1194265,00.html. Question for anyone: I used the wizard to copy 12 databases from ServerA to...

Download files from a sharepoint site using SSIS.

Hi, i want to download multiple files from a sharepoint site using SSIS Script task with VB script. I am unable to write script.

How to create an SSIS package for importing an Access table to SQL Server, running SPs and exporting data to Excel

I need to create a SQL Server Integration Services (SSIS) package for importing an MS Access table into SQL Server, then running some stored procedures on this database and finally exporting the result to Excel. I am comfortable in writing queries and working in Management Studio but I don’t...