Scenario: Production servers are running SQL Server 2008 in the domain myDomain.com Dev/test/stage servers are running SQL Server 2008 in the domain dev-myDomain.com Actual dev work done on local running SQL Server 2008 source controlled using SourceSafe First of all, does this setup/environment make sense? And, what are some good wa...
There are 5 different types of logging in SSIS Event Log Text File XML File SQL Server SQL Server Profiler I am in a production environment where developers do not have access to production systems. Which logging method should be my poison of choice, and why? ...
I need to create an SSIS package that will do the following: Connect to Service A and download recent activity records. These records contain an User Id and an activity code. Iterate through the results of the result set from Service A and connect to Service B retrieve additional details for each User Id (name, department, etc.). Put a...
How do you call an SSIS package using a Web Application? I'm using SQL Server 2005. I prefer a solution in C#2.0 above. Any help will be greatly appreciated. Thanks in advance. ...
I am using Excel to generate a whole slew of INSERT statements, similar to the process described here. I would like to have an SSIS package that will run through each row of this excel file and run the SQL statements it finds against a database. Is this possible? EDIT: As John points out - there is a better way to do it - generate th...
Hi When I set permissions on an SSIS package (ProtectionLevel) & I enter a PackagePassword, then when I open the package on my computer, it does not prompt me for a password. Am I doing something wrong? ...
For the warehouse work under progress, we have a single solution with multiple projects in it OLTP Database Project Warehouse Database Project SSIS ETL project After the SSIS project is built, I want to move the binaries (XML, really) from the Bin folder to "C:\AutomatedTasks\ETL.Warehouse\" and "C:\AutomatedTasks\ETL" I cannot find...
I run an "Execute SQL Task" in SSIS It runs a stored procedure which does some validation In the Stored Procedure I have a RAISERROR command when something goes wrong. However when I test for this, this task fails to abort. I have Googled about this and found lots of references, but no solution that works for me. I have upgraded my SQL S...
Please recommend books/blogs to learn adavnced SSIS (2008) ...
Hi, For my requirement I need to write Script task from One SSIS package to another. As my server is 64bit machine, when I execute the overriden SSIS package, it throws the error "Binary Script not found". Hence I need to compile the script programmatically in the Parent SSIS package and put the binary code into the another one. I dont k...
My main question is how to copy a whole database having a English collation to one having a Greek collation? The source database is having all the tables and the related data. I have a clean Greek collation database. I want to copy everything from source to destination. One solution that I found in a KB article, consisted of the followi...
Hello! I have a problem, i didn't found yet the solution so i am asking your help. In my database I have some int, decimal and string that needs to be convert in numeric with specific length and precision to include in a flat file. ex: integer 123 to numeric(8,0) ==> 00000123 decimal 123,123 to numeric(8,8) ==> 0000012312300000 String...
I am building an SSIS package and getting an error when setting "Name of the table or the view" in the OLE DB Destination editor. SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x8007000E. An OLE DB record is available. Source: "Microsoft SQL Native Client 10.0" Hresult: 0x8007000E Description: "Not e...
Hi There, I have problem loading the CSV file as the connection manager editor settings are out of my knowledge. When i load the csv file up to 18 rows i have no problem it is loading in to the table. from the 19th column the data is not partioning correctly. row delimeter is {CR}{LF} column delimeter is Comma {,} how do i partion the d...
I am trying to debug a dts package in SSIS. I have a script component designer where I pass in the input variables to increment a counter. When I try to msgbox the counter value, I get the following error. Error: 0xC0202009 at STAGING1 to STAGING2, STAGING2 Destination [1056]: An OLE DB error has occurred. Error code: 0x80040E14. An ...
Hi, I am trying to execute a SSIS 2008 package on a 64-bit OS and import Excel 2003 files to SQL Server 2008. I have created an OLEDB Connection to the Excel file with a Connection String that retrieves the Excel file from a variable, inside the ForEach Loop Container. The Run64BitRunTime is set to false. I am not able to edit the SQL ...
Is it possible to dynamically change the way SSIS packages log events to SQL Server (or the file system etc)? I would like to have different events logged based on the environment the package is running in. For example, in DEV I would like to log more detail of the package execution than I would in PROD. SSIS has a configuration interfa...
My question is similar to Upgrading SQL Server 2000 to 2005 or 2008 - DTS to SSIS but I have a few restrictions that I'd like the community to consider. We have two databases that currently run on SQL Server 2000 and we are being pushed to move off of this in favor of SQL server 2005 (We do not have 2008, it isn't an option). We have...
Hi Is there any way to check Date(like isDate function in TSQL) column in SSIS package derived column expression after extraction from Sourcefile before loading to target dtabase? Thanks ...
I have scheduled sql agent task which runs an SSIS package. I want to be able to run the SSIS package from .net. Is there a way to either run the SSIS package directly or at least run the SQL agent task which would in turn run the SSIS package. If it helps it is for a .net 3.5 web app written in C# Thanks! ...