Questions tagged [ssis]

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

Filter by
Sorted by
Tagged with
2 votes
1 answer
190 views

SQL server Intergration services 2008 sub queries

I am looking for a way to execute sub queries from within a main query that I execute in my SSIS package. So When I execute the package, I want to be able to execute the sub query after everyline ...
hadEnoughOfKeyboardGangstars's user avatar
0 votes
1 answer
52 views

SSIS Bug - Flow Components going blank

Every time I change tabs in SSIS or minimize/maximize the program, every node loses everything but its text, making it very hard to follow the diagrams. The image/border/etc. returns when I click on ...
BlueRaja's user avatar
  • 1,166
1 vote
2 answers
536 views

Can SSIS transfer data from a SQL Server 2005 database to a 2008 database?

I need to transfer data on a regular automated basis from a database running on a SQL Server 2005 instance to a remote database running on a SQL Server 2008 instance. I'm new to database ...
Andrew Corkery's user avatar
0 votes
3 answers
756 views

BIDS and SSIS projects on SQL Server 2005

I have trouble just getting started with BIDS, the development environment for creating SSIS packages in SQL Server 2005. I don't know if it is just a license / version issue or if i am missing some ...
Francesco Abeni's user avatar
0 votes
1 answer
3k 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 ...
David Mackey's user avatar
2 votes
3 answers
2k 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 ...
blntechie's user avatar
  • 141
0 votes
1 answer
177 views

MS SQL dts to ssis migration error

I have migrated some DTS packages to SSIS 2005 using "Migration" wizard. When I tried to run it, it fails saying you need a higher version of SSIS even though the destination SSIS server is on 9.0....
Manjot's user avatar
  • 333
0 votes
1 answer
779 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) ...
alimack's user avatar
  • 963
0 votes
2 answers
3k 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 ...
alimack's user avatar
  • 963
0 votes
1 answer
1k 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 ...
alimack's user avatar
  • 963
3 votes
2 answers
9k views

SSIS: How to create and export data to Microsoft Access 2003 database?

Goals - Automate exporting SQL Server 2005 views to Microsoft Access 2003 database (no transformation required) through SQL Server Job (with SSIS package) There is no "Access DB Destination" in BI ...
dance2die's user avatar
  • 2,031
0 votes
1 answer
233 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 ...
dance2die's user avatar
  • 2,031
0 votes
1 answer
3k 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 ...
user155695's user avatar
5 votes
2 answers
20k views

Can I tell the last modified date on an SSIS package from Integration Services

Using SQL Server 2005 (and 2008) With a DTS package, I can open it, and it lists the date that the package was last modified. I have some SSIS packages, and I need to know if they have been modified ...
thursdaysgeek's user avatar
1 vote
2 answers
379 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 ...
user avatar
1 vote
1 answer
39 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 ...
Tereno's user avatar
  • 153
4 votes
2 answers
8k 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: ...
Thomas Jespersen's user avatar
0 votes
1 answer
404 views

Connect to SSIS from within Management Studio

A newbee question: Connect to SSIS from within Management Studio? I have a running service named: Integration Services 10.0, but from within Management Studio, I don't know how to connect to it, it ...
Peter's user avatar
  • 101
0 votes
1 answer
3k 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 + ...
ProfK's user avatar
  • 493
0 votes
1 answer
308 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} > ...
Rob Stevenson-Leggett's user avatar
3 votes
5 answers
475 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 ...
Saif Khan's user avatar
  • 1,965
3 votes
4 answers
2k 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, ...
Moo's user avatar
  • 2,264
0 votes
2 answers
2k 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 ...
Steve's user avatar
  • 113
3 votes
3 answers
33k 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 ...
JD Long's user avatar
  • 445
0 votes
1 answer
337 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 ...
phill's user avatar
  • 327
1 vote
1 answer
820 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 ...
phill's user avatar
  • 327
3 votes
4 answers
6k views

can SSIS connect to another sql server?

Can an SSIS package run on one SQL Server instance but process data that is located on another SQL Server instance? I'd like to know this before I attempt to install SSIS and require a possible ...
phill's user avatar
  • 327
0 votes
2 answers
3k 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 ...
phill's user avatar
  • 327
3 votes
3 answers
13k views

SQL Server 2005: Copy SQL Server Agent Job?

I have a SQL Server Agent job comprised of 10 steps and each step has many parameters defined. Now I need another job almost exactly the same, but with a few differences. Since "copy / paste" isn't an ...
Chris_K's user avatar
  • 3,434
1 vote
1 answer
950 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 ...
Dillie-O's user avatar
  • 531

1
2