SQL Server Integration Services, used for data migration in and out of Microsoft SQL Server

learn more… | top users | synonyms

0
votes
1answer
2k views

Access SSIS Projects Stored in MSDB Database in BIDS?

I have a database server (db1) that has SSIS installed and configured (SQL 2008). I have configured it so I can remotely connect to SSIS through SSMS. Now I am trying to open one of these SSIS ...
2
votes
3answers
1k views

Problem transferring file to FTP server - 503 Could not create file

I try to transfer a file from SSIS package to a FTP server provided by my client. When I try connecting and transfer using a FTP tool (WinSCP) manually it works fine and file was transferred. But when ...
0
votes
1answer
501 views

SQL Server Agent 2005 job runs but provides no output

Essentially I have a job which runs in BIDS and as as a stand lone package and while it runs under the SQL Server Agent it doesn't complete properly (no error messages though). The job steps are: 1) ...
0
votes
2answers
2k views

SQL Server 2005 Agent running SSIS job can't find file path

Basically I'm trying to run a functioning SSIS job (created in BIDS) under the SQL Server Agent - it reads a set of Excel spreadsheets and dumps the results into a table. The problem I'm having is ...
0
votes
1answer
932 views

SSIS Foreach loop (SQL Server 2005) adding loop variable causes failure

I'm trying to use SSIS to traverse a directory of Excel files and put them into a table in SQL Server. I seem to have a basic choice - either I get the same spreadsheet dumped in the table 10 times ...
1
vote
2answers
352 views

SQL Server 2008 SSIS package compatability

I am trying to save an SSIS package on a sql server running 2005. The issue I have is that I am using SQL Server Management Studio 2008 on my local machine to do this and it won't let me save the ...
3
votes
5answers
441 views

Executing SSIS package

I posted my question on stackoverflow but I was told that it might be better off here. I have a problem executing my SSI package from command line. I created the package via SQL Server Business ...
0
votes
1answer
201 views

How to remove database backups 2 days or older through SQL Server 2005 Integration Service?

I have a simple Integration Service package which has one SQL Task as shown below; WLSTAGE Bakup using Red Gate: Calls master..sqlbackup to backup database Here is the SQL to run the actual backup ...
0
votes
1answer
2k views

SQL Server; how to import data from another DB with different collation; conversion errors?

I have 2 databases setup on a server. I want to import data from DB1 to DB2, using the SSIS wizard (right click DB > Tasks > Import Data) DB1 is the source DB, it has a collation set to ...
1
vote
1answer
28 views

Server Side Includes for certain files

at the moment, all of my .shtml files are being parsed by SSI. Some of these pages do not have SSI and it would be more efficient if they did not have to go through SSI. Is there anyway to specify a ...
2
votes
2answers
6k views

How can I Import Data using SQL Servers SSIS, when using foreign key constraints?

I'm trying to set up an import form live database to our development database. I trying to do this using SSIS, but the import is failing because of constraints. E.g. I have the following tables: ...
0
votes
1answer
2k views

Fixed Length Field Export from SQL Server

How do I go about exporting SQL Server 2005 tables to a fixed length field text file, with one record per line? SQL seems to think fixed length is the only way to delimit records, i.e. fieldLen1 + ...
3
votes
3answers
25k views

Installing ONLY SSIS and not the whole SQL Server system?

I have a production SQL Server 2008 running on Windows Server and I do testing and development on my laptop. My laptop is running Win XP and SQL Server Express 2008. In addition to having SQL Server ...
0
votes
1answer
284 views

SQL Server 2005: Copy database failing with unhelpful error

> Event Name: OnTaskFailed Message: > Operator: ***\administrator > Source Name: > ***_Transfer > Objects Task Source ID: > {9135C978-DD50-4418-A843-7E8FCE455181} > ...
3
votes
4answers
1k views

Unix and Triggering MS SQL Server Integration Services Jobs

We have an AIX server which contains a lot of data, and once a night we dump that data to CSV for import into MS SQL Server for reporting reasons. At the moment, each step in the process is unlinked, ...
0
votes
1answer
214 views

sql server sp2 doesn't update ssis

the company i work for is installing a program which requires it to run on SQL Server Service pack 2 which uses SSIS to import data. I just installed SQL Server service pack 2 and I noticed it will ...
0
votes
2answers
1k views

Exporting/restoring Multiple SSIS DTSx packages to file system

Is there a way to export and import multiple dtsx packages from SQL Server 2008? I'm trying to find a built-in way/free tool/script to automate right-clicking the package, selecting "File System" for ...
1
vote
1answer
629 views

odbc connect to cluster node error

I recently installed SQL Server Integration Services onto one of the nodes of a single cluster thats running windows 2003 enterprise. When I attampt to create a system odbc connection to the database ...
0
votes
2answers
2k views

how do you install SSIS on a cluster environment

I'm running SQL Server 2005 enterprise edition on a 2 node active-active cluster windows 2003 server. I go to add/remove programs, click on SQL Server and then the link for "to install a new ...
0
votes
1answer
433 views

Why is my SSIS configuration update not being saved?

I asked this over on SO with little success. I was wondering if any SF folks had some insight... I have a SSIS 2005 package that is up and running in our production environment. The package uses an ...