Viewing 15 posts - 136 through 150 (of 3,232 total)
Ah, you will not get SSIS to read directly from the Paradox files. SSIS may be able to connect to a Paradox instance and read from it, but not...
October 8, 2015 at 9:36 am
I don't think the FTP task allows for SFTP, but I'm not 100% on that. If it does not, a Google search for SSIS SFTP gives you a number...
October 8, 2015 at 8:42 am
Great solution Jeff. I'd say that would work great as long as the OP has the ability to create tables for their ETL. I've worked on projects where...
October 8, 2015 at 8:35 am
Looks like 2GB is your limitation on XML data.
https://msdn.microsoft.com/en-us/library/hh403385(v=sql.110).aspx
As far as the question on how to store it, you can define a column in a table with a...
October 7, 2015 at 4:51 pm
Why not build the FTP portion of the process into the SSIS package? If you store the FTP parameters in a table, you can query the contents of that...
October 7, 2015 at 4:45 pm
This error is telling you that you've configured the object transfer to contend with Identity values, but your target table does not actually have an IDENTITY column in it. ...
October 7, 2015 at 4:39 pm
I am not sure what those file extensions represent, but you can configure a For Each Container to move through a directory and process each file with a given extension....
October 7, 2015 at 4:29 pm
Not sure how large your table is, but here's an example of how to solve the problem with a cte...
DECLARE @Purchases TABLE(CustomerID int, PurchaseDate date)
INSERT INTO @Purchases
SELECT 1234, '05/15/2010' UNION...
October 7, 2015 at 2:48 pm
He just means that you can use the object browser to find your table under the linked server. When you drag an item from the object browser into the...
October 7, 2015 at 2:14 pm
I'm not sure I follow 100%, but at the very least, you'll need a linked server and to fully qualify your table names in your sql statements. Even the...
October 6, 2015 at 4:54 pm
Glad you got it to work. I saw your post late yesterday, but didn't have time to answer it. I've also made the jump from VB to C#...
October 6, 2015 at 4:51 pm
There are many ways to tackle this, and you say what tools do you have...but then you say it has to be a stored procedure. Why does it have...
October 6, 2015 at 4:48 pm
You still have the Header and Trailer rows to contend with. A flat file source will allow you to skip the header, but not the trailer and it sounds...
October 6, 2015 at 4:26 pm
Yeah, the equivalent data type will be a numeric on SQL Server, but his destination is an integer. I've seen systems that used large numeric data types, but only...
October 6, 2015 at 8:27 am
I tested this and it works just fine. If you pad the varchar values in the source component, they will retain their trailing spaces all of the way into...
October 5, 2015 at 4:26 pm
Viewing 15 posts - 136 through 150 (of 3,232 total)