I have an SSIS Package that I have added to an existing job. However, I move servers a lot. Does anyone know how I can dynamically set the server names in the SSIS package?
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2330...
Hi,
I'm using a foreach loop to loop through file names in a folder and then bulk insert the data into tables. What is the easiest way to run the bulk insert processes in parallel?
The file f...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/DTS/Q_23521949.html
Hi Experts,
I am using SQL 2005 Integrations Services and am copying data from my SQL 2005 database to a SQL 2000 database using the Transfer SQL Server Objects Task.
However, if I use window...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_22051758.html
I have successfully been connecting to an Avaya CMS database (Informix on Solaris) using the provided OpenLink ODBC driver using SQL Server Integration Services. I export some of the data to a SQL ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2324...
Hi everybody,
I'm newby in SSIS. I have been using DTS in SQL 2000.
Trying to learn how to execute SSIS package from C# code of ASP.NET web server.
For now testing with console app.
Here'...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/DTS/Q_23300823.html
Bit of a conundrum here. SQL server management studio has a generate scripts function that allows you to script any operation that it performs, except one. It doesn't offer the ability to script th...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/DTS/Q_23513933.html
Is there a way to connect to an access database and update all "Hire Dates" based on employee ID from a SQL server 2005 table?
I think I can do it via TSQL using:
-- code
FROM OPENDATASOURCE(...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2366...
How to execute logic against an excel data source with SSIS 2005
I get a file from HR weekly. This file contains HIRE and TERM dates. Unfortunately all the dates are in 1 column and they are sep...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2368...
I would like to create an SSIS package to query a .xls file, use a pivot function, then push the results to an Access2003 table. I do not want to create staging table in a SQL server database unles...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2369...
I have an SSIS package that runs another package in a for loop. After the child package runs, it stays open in the designer and all the control/data flow tasks stay green.
When the package exec...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/Q_23797442.html
Zones:
SSISDate Answered: 10/13/2008 Grade: A Views: 4
