Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [ssis]

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

77 questions
0
votes
2 answers

Automatically set up user's subscription in SSRS

I have a very simple report in SSRS that is just a table with three columns, an object name, client account, and expiration date. In my report, I include a filter by UserID to limit the data to just the logged in user's client accounts. I store the…
senloe
  • 111
  • 1
  • 6
0
votes
1 answer

Possible to connect securely to remote MySQL using SSIS?

I've downloaded an ADO.NET and ODBC connector from the MySQL website. I'd like to access a remote MySQL server from within BIDS with the goal of importing the remote data and populating a local SQL Server database. While it looks like making the…
MattB
  • 238
  • 2
  • 3
  • 10
0
votes
2 answers

Two way synchronization with SSIS?

Can I use SQL Server Integration Services (SSIS) to create a two-way synchronization between tables in two different databases? I am using SQL Server 2008 R2. If it is possible, then how do I handle synchronization conflicts?
Jan Aagaard
  • 175
  • 1
  • 9
0
votes
1 answer

MSSQL: SSIS 2005 transfer logins task

I created an SSIS package to transfer logins from one server to another in SQL 2005 SSIS project using BIDS. I want to transfer all packages but skip 3. So I changed the maximum number of error count to 3. But it didn't help. can anyone please help…
Manjot
  • 333
  • 1
  • 3
  • 17
0
votes
1 answer

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 a node. Has anyone else experienced this before?
BlueRaja
  • 1,096
  • 1
  • 11
  • 18
0
votes
3 answers

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 components. If i install SQL Server Express 2005,…
Francesco Abeni
  • 575
  • 1
  • 4
  • 14
0
votes
1 answer

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 projects that is in the MSDB database? I know in SSRS it…
David Mackey
  • 697
  • 2
  • 15
  • 30
0
votes
1 answer

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.4211 level. then I digged in the package using…
Manjot
  • 333
  • 1
  • 3
  • 17
0
votes
1 answer

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) Delete all rows from table; 2) Use For each loop…
alimack
  • 943
  • 2
  • 11
  • 22
0
votes
2 answers

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 getting the SSA to read the file path, the relevant…
alimack
  • 943
  • 2
  • 11
  • 22
0
votes
1 answer

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 or I get an error message. I'm using the…
alimack
  • 943
  • 2
  • 11
  • 22
0
votes
1 answer

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 SMTP Connection Manager to send an e-mail message…
Dillie-O
  • 521
  • 8
  • 15
0
votes
1 answer

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 exec master..sqlbackup '-E -SQL "BACKUP DATABASE…
dance2die
  • 2,011
  • 7
  • 32
  • 41
0
votes
1 answer

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 Cyrillic_General_CI_AS DB2 is the destiantion DB, it has a…
user155695
  • 290
  • 3
  • 5
  • 14
-1
votes
1 answer

ADO NET Destination has failed to acquire the connection with the following error message: "Login failed for user

Created a SSIS package, it is running fine when I run it on premise but when i try to execute it from sql server agent it gives me error for login failed for user, I am using SQL authentication to connect to the Azure database which are working fine…
Akki
  • 1
  • 1
  • 2
1 2 3 4
5
6