Could not load type 'Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSPackageSigning100' from assembly 'Microsoft.SqlServer.DTSRuntimeWrap, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' ...
HI Everyone, I have SSIS packages which runs on nightly basis to move data from AS400 to SQL Server 2005. From last couple of months my packages consuming more time to complete as a scheduled job. If I run same packages manually they are completing normally . In all my ssis packages i am truncating the data in sql server then Bulk inser...
Hi, I have a row count inside a foreach. I want the variable to have the total number of records that passed through in all iterations of the for each - cumulative sum. However, it seems that only the last iteration holds. Is there a way to do this? Thanks ...
Is it as simple as deleting the file, or do I have to do anything to de-register it before I delete it. Does the deployment process do anything more than copy it to the "Packages" folder. ...
Is it possible to access .NET 4 Framework references using BIDS 2005? Specifically to trigger a WorkFlow. I have a dll built in VS2010 using the .NET 4.0 and would like to access the methods/fields in it. in VS2010 I would be able to Import System.Activities and use WorkFlowInvoker.Invoke I need to be able to do this in BIDS 2005 usi...
I have Visual Studio 2005 (BIDS) set to "Check out automatically" when a file is edited which works well for most file types. When I access a Data Flow within an SSIS package though, a check out is triggered without me making any changes. When I compare the files, there does not appear to have been any changes made in the background eit...
Hi there, When converting from DT_Decimal to DT_Str, the derived column stips off decimals from my result. ex.: -0.1250 returns -0.125 -2.0000 returns -2 Is there a way to keep the zeros to have a final string with always four decimals ? Here is my derived column for the decimal value calculation: (DT_DECIMAL,4)ROUND((DT_Decimal,4)[...
I have a small problem (I assume...) I'm loading a flatfile (csv) and I want to add a rownumber to the dataflow. Using the RowNumber transforation works good for both output paths (source and error) individually. But what if you want to use the same rownumber in both paths to be able to track where (in the file) an error occured. I have ...
Here when task is failed in Script Task, I always get a result as "Error: The script returned a failure result" in the Progress/Execution Result Tab, which I am unable to identify what error had occurred. Inside the script task, I have given the code for failed result, as shown : Dts.TaskResult = (int)ScriptResults.Failure; How will I...
I have a variable @csv which hold a comma separated value such as: -a -a,b -a,b,c I need to pass it in a query in my OLE DB source in a data flow to create a query such as: SELECT COUNT(1) FROM table WHERE col1 IN @csv So if @csv="a,b" then internally it should resolve into SELECT COUNT(1) FROM table WHERE col1 IN 'a','b' How can t...
Hi all, I am new to stackoverflow, and this is my first question: I would like to create a SSIS task on SQL 2005 server that queries a specific email account on an Exchange 2003 server, and creates a report. The report currently contains the amount of emails received, average time of reply, and emails with reply time that have gone ov...
I have an SSIS package set up to pull data from an Oracle database into SQL Server. I recently ran into an issue that was preventing this data pull. The following code works fine in Oracle SQL Developer (it returns rows, as it should): SELECT a.MyField , a.MyOtherField, a.FromDate FROM MyTable a WHERE a.FromDate BETWEEN CONCA...
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: * Customers * Products * OrderLines * Orders Importing Customers and Products is fine, because they do not depend on anything. But when importi...
Anybody knows how, if at all, can I convert an SSIS package created in VS 2008, for SQl 2008, to be loaded in VS 2005, for SQl 2005? It is a simple file copy and looping package. No fancy stuff in it. ...
Hi, How do I execute an SSIS Package based on a flag bit present in a table. What I understand is, we need to create a variable and then get it assigned with the value in the SQL Server Table. And then use the precedence constraints to control the flow. If my flag bit is "0" I will run it and make it 1 at the end, but if it "1" I sh...
I'm currently working on a SSIS package and after the 80th time using FireInformation inside a Script Task, I have to wonder: why would the method require you to pass in a ref boolean as its last parameter? The documentation doesn't state anything about how you should respond to the value once the method returns. Am I missing something h...
Hi, In my SSIS 2005 package, I need to give the FTP Connectionstring via an expression as I need to keep it configurable for the user from the dtsConfig file. At the moment I tried giving the following expression: Connectionstring = @[User::FTPServer] + "." + @[User::FTPUser] + "." + @[User::FTPPass] For this unique syntax, I took poi...
Hi, In SSIS 2005, I am using the FTP Task. I have a flow where when the package runs, it retrieves any files in a specific folder from FTP to a local folder. Remote folder path is set by variable such as /root/abc/*abc.txt The task works fine if there are files in that folder matching this criteria. If there are no files, the task fail...
I'm writing a custom SSIS task. At the moment, each time I make a code change, I'm having to recompile and re-gac the containing assembly, restart my test SSIS package, delete and re-add the task from the tool box, then re-add the task and run the package. Does anyone know if there's a way of stepping through my custom ssis task code at...
Im having a problem with derived columns in SSIS. When in SSMS i can set a column to have a default value using the following code: (dateadd(month,datediff(month,(0),getdate())-(1),(0))) and when data is entered into the database it will give it the timestamp of the previous month in the following format for example: 2010-09-01 00:...