Hi i wish to modify a string. In ssis I have a step which is a "Derived column transformation editior". I have a string such as: edit=style?form=exy?test=x~~StringIWantToRemove I wish to remove "~~StringIWantToRemove" "~~" is the delimiter "StringIWantToRemove" is a random string og any value (apart from the delimiter) I would try ...
I receive this error when I try to connect to SQL Server 2005. I have enabled TCP/IP, Named Pipes, and restarted the server but that is not working. ...
I have an existing SQL Server 2005 database that runs our accounting/inventory application. We are looking at using a new on-line ordering framework - which has it's own database. If we use this new framework, we will need to transfer the on-line ordering data (inventory, prices, orders, customers) - almost realtime - to and from, our ...
Can someone tell me what this SSIS package is all about?I am totally new to data-warehousing and I am going crazy with the terms SSIS,DTL,ETL and so on.I am looking for a big picture and how it fits in the overall .NET/SQL Server architecture. ...
I am trying to remove part of a string from another string, for example: declare @url varchar (20) set @url = 'www.test.com~~34235645463544563554' select @url, substring(@url,1,CHARINDEX('~~',@url)-1) I am trying to remove '~~34235645463544563554' I am use to using the built in tsql functions (as shown above) to do this but trying t...
Unfortunately we do not have the required DCOM access to the SQL Server mentioned in this MSDN article but we do have full admin rights on the SQL Server instance. We can therefore successfully deploy a package to the server and run it using the SQL Server agent but I cant work out how to delete a package from the server. The only thin...
I'm trying to extract the substring trackingCode to the point of the delimiter ~~. So for example: www.test.com~~34235645463544563554 I wish to return: www.test.com i am using: SUBSTRING(trackingCode,1,FINDSTRING(trackingCode,"~~",1) - 1) But it is not working and I'm getting an error: Error: 0xC0049067 at aw import from ...
I have an SSIS package that I've saved under Maintenance Plans on SQL Server 2005. Though I can select SSIS packages, I am not sure how I can delete them. ...
Being an SSIS newbie, I am trying to figure out the best possible way to transfer multiple tables. I am trying to import multiple tables from one database to another. I could write multiple parallel data flows for each table, however, I want to be smart about it. For each of the tables, If I were to generalize, I need to transfer ro...
I have the same database running on two different machines. The DB's make extensive use of Identity columns, and the tables have clashed pretty horribly. I now want to merge these two together before sorting out the undelying issue which I may do by A) Using GUIDs (unweildy but works everywhere) B) Assigning Identity ranges, kind of na...
I have a script component which I need to reference a global variable? I guess I can dtsconfig file. How do I set this and read it back out from my script component? ...
We have a data-warehousing package that our clients run during the day against their live transactional system. On most clients this seems to work fine but on busy clients we get deadlocking errors. By default SSIS runs with an isolation level of Serializable which is the highest isolation level on SQL 2005. The SSIS package is only ...
Is there a way to unit test data flow in a ssis package . Ex: testing the sort - verify that the sort is porperly done. ...
I've got Dim Tables, Fact Tables, ETL and a cube. I'm now looking to make sure my cube only holds the previous 2 months worth of data. Should this be done by forcing my fact table to hold only 2 months of data and doing a "full process", or is there a way to trim outdated data from my cube? ...
I've never used a JDBC connection before, and am familiar with only ODBC connections. We have a vendor who will only support JDBC. They consider ODBC 'Open Source', and therefore do not support connections to their DB through an ODBC connection. Does anyone know if it is possible to create an SSIS connection via JDBC? I am not getting an...
I've created an SSIS package that needs to execute a MySQL SPROC with an output parameter. The MySQL SPROC works fine from Query Browser. The problem is that the @ character is used to mark a SSIS variable and also is used as a MySQL sproc variable for output. The step does not work in SSIS. Does anyone know a fix? ...
A while back I needed to parse a bunch of Serve-U FTP log files and store them in a database so people could report on them. I ended up developing a small C# app to do the following: Look for all files in a dir that have not been loaded into the db (there is a table of previously loaded files). Open a file and load all the lines into ...
I am migrating data that has to be inserted using stored procedures which already exist. The stored procedures have parameters and a return value (from a select statement) of an id for the row inserted. Within an OLE DB Command in SSIS I can call the stored procedure passing column values as the parameters and I usually use output paramt...
We have written a number of SSIS packages that import data from CSV files using the Flat File Source. It now seems that after these packages are deployed into production, the providers of these files may deliver files where the column order of the files changes (Don't ask!). Currently if this happens, our packages will fail. For exa...
Is there any way to get the benefits of SSIS 2008 (including the performance improvements) while still working with a SQL Server 2005 database? It seems like it still pulls the data from OLE, so I don't see how it would be a problem. I'm running the package from the dtproj file, not loaded onto the server. ...