I would like to automate the deployment of my SSIS and SSAS artifacts to remote development SQL Server 2005 & 2008 instances on a scheduled basis. What would be the best solution for this? I am using TFS 2008 as the source control system, so I'd like to integrate the solution with MSBuild and a scheduled Team Build. ...
Hello I have a hosting account with servergrid.com. I want to backup my database, they say I have to use Sql Server Integration Service to backup the database and I would need a commercial version of Sql Server management studio. I have Sql Server 2005 Developer Edition. I have no idea how to do SSIS backup. I tried playing around with...
I have a table with 7M records I want to trim down to 10k for dev. I tried a delete, but the whole world was nearly overpowered by the transaction log size, so I truncated the table. Now I wish to insert 10k records from the original table, into my dev table, but it has a identity column, and many, many other columns, so I'd thought I'...
Hi, In C#, I am calling a SSIS package. I have to pass it 3 parameters, how do I do that? ...
Hi, when calling a SSIS package (C# app) using LoadFromSqlServer, does the user account have to have any special permissions on the database or server? I can't seem to view the packages in EM at the moment ... ...
I am creating a script on the fly to ftp some files from a remote computer. I create a file which is then called from the command line with ftp -s:filename proxy where filename is the file I just created. The file has code similar to the following: anonymous@ip address username prompt off binary cd c:\destination directory mget c:\...
I have an SSIS package that executes several tasks. I manually added an event handler inside Business Intelligence Studio 2005 at the package level for the OnExecStatusChanged event. My question is, how can I add a handler for this event inside C#? I have loaded the package as pointed here and I also created a custom class inherited fro...
I have a slow custom data source in a SSIS Dataa Flow Task.I have to run the package with multiple parameters If I want to upload data to a DB using SQL Data Destination(Bulk Insert) the connection times out If I write the data to a flat file I cannot run multiple instances of the package, since they will write to the same file. Can I ...
I have an SSIS package that connects to a mysql server and attempts to pulls data from different tables and inserts the rows into a SQL Server 2005 database. One issue i notice is that at any given time it runs, regardless of what step it is on, it almost always fails to bring in the total records from mysql into sql server. there are ...
I want to gather data from different data servers located in Europe and Asia. Rather than running a plain data query task that will clog up the undersea network I am thinking of a couple of machines that will be available for me at the local sites. I am thinking to design the master package so that I can: run remote setup tasks launch...
Hi, Having some SSIS permissions issue. I am calling the SSIS package in my .net console application with: Package pkg = app.LoadFromSqlServer(packagePath, serverName, serverUsername, serverPassword, dtsEvents); It is working when manually running it using the windows accout, but fails with the above call in my console application. ...
I have an SSIS package that does the following: Selects the connection strings from a table of servers. The connection string is either the name of the server along with the domain (i.e. Dalin.myhouse.com) or is the direct IP to a server. The package iterates through each connection string and populates a defined 'global' variable. Th...
When I call a SSIS package using LoadPackage() from a .aspx page (or windows service), how do I setup permissions for it to work? Event viewer is reporting a Sql server error: Login failed for user 'NT AUTHORITY\NETWORK SERVICE'. Reason: Failed to open the explicitly specified database. [CLIENT: 192.168.73.118] How do I give that acco...
I've been working on some data transformation tasks in SSIS. Visual Studio has gotten better in 2008 in it's usability, but I find there are some things that annoy me (i.e. When I delete something in the Package Explorer it refreshs the whole screen bringing me back to the top of the tree. Also, lack of some keyboard shortcuts.) Is there...
Hi Fellows, I found the Excel 2007 Binary format (with extension .xlsb) perfectly suitable for my needs, since it's fast to load and very compact. I deliver a bunch of reports in Excel that carries a lot of data, and those reports are actually being loaded with a IS package. So I assumed the conversion to this very format, read docu...
Hi, I need to convert a flat file to DB using MS SSIS. I need a way to look into a particular folder to fetch the (only) flat file, filename is of the format "FileName-CCYYMMDD.txt". Please help me if there is way to add a file from the folder OR Get a file name of the format "Filename-CCYYMMDD.txt" where is CCYYMMDD is the current d...
I am ftp'ing files from an external server, then deleting them on the external server, and one file failed because there was a space in the filename. I changed my ftp delete command to have quotes around the filename. ftpStream.WriteLine("delete """ & FileToDelete & """") But, are there other characters that a user might use in their...
Hi, I'm calling a SSIS package using LoadPackage(...). Is it possible to make this call an Asynchronous call? ...
What is the best method using SSIS (SQL Server Integration Services) to upload a file to either a remote SFTP (secure FTP with SSH2 protocal) or FTPS (FTP over SSL) site? I've used the following methods, but each has short-comings I would like to avoid: COZYROC LIBRARY Method: Install the CozyRoc library on each development and produc...
By default, are SSIS packages thread safe? Can they be called in parallel? (in general) ...