COZYROC

Forum Replies Created

Viewing 15 posts - 346 through 360 (of 1,118 total)

RE: Trying to change the date format while casting a data type

Check this post.

June 8, 2010 at 5:52 am

#1177405
RE: SSIS ForEach file on FTP site

Holly Kilpatrick (5/28/2010)
Right after I posted the above, I found a suggestion on Microsoft Connect from 2008:
"There is currently no way to enumerate files in an FTP folder using SSIS....

May 28, 2010 at 11:35 am

#1174078
RE: Script Task to update table using Connection Manager connection

You CANNOT uses OLEDB connections from script. You have to use ADO.NET connections instead.

May 25, 2010 at 6:49 am

#1172024
RE: Looping through files in FTP Site folder is possible or not?

saidwarak01 (5/21/2010)
I want to know the names of the zip files and its creation time and I am not concerned about the contents inside the zip files. The...

May 25, 2010 at 6:44 am

#1172022
RE: Unzipping/Importing Multiple Files

If you can use third-party solutions, check the commercial CozyRoc Zip Task. It supports Zip, GZip, Tar, Unix, BZip2 and it is completely integrated in SSIS.

May 25, 2010 at 6:29 am

#1172011
RE: How to send many files to FTP server

RexSmith (5/20/2010)
Hi Cozy/all,
Can you post a sample snippet of script task reading data like userid/password/ipaddress from some flat file and using these as variables in the code.
Instead of declaring environment...

May 20, 2010 at 6:28 am

#1170055
RE: How to read data from file (not well formatted) with ssis

asita (5/19/2010)
Hello Cozy,
its about 200 kb (around 7000 records in it)
thanks & Regards
asita
Okay. This is not very much. You can do it one line of code:
...

May 19, 2010 at 10:36 am

#1169590
RE: How to read data from file (not well formatted) with ssis

asita (5/18/2010)
Hello Rjv,
thanks alot for your code, it gave me good idea , and i substituted in my code it is working fine
so now i have the whole cleaned data...

May 19, 2010 at 8:04 am

#1169438
RE: whats the advantage of SSIS tool over other ETL Tool

imani_technology (5/15/2010)
I'm an old SQL Server guy, so I agree with you guys. It's just that we've had some proof of concept tests, with me advocating SSIS. For...

May 18, 2010 at 3:16 pm

#1169132
RE: How to use SSIS to populate a fact table that needs to reference multiple fields in SCD2?

peterzeke (5/14/2010)
Soon after posting my question, I stumbled upon the following links that may provide a solution:
http://www.julian-kuiters.id.au/article.php/ssis-lookup-with-range
http://blogs.msdn.com/mattm/archive/2008/11/25/lookup-pattern-range-lookups.aspx
If anyone has additional suggestions, please feel free to share.
CozyRoc has implemented data flow...

May 18, 2010 at 12:22 pm

#1169021
RE: How to read data from file (not well formatted) with ssis

Use script to remove carriage return (CR) line feed (LF) characters. Then use the regular flat file source to load the file. For a sample script, which can help take...

May 18, 2010 at 12:18 pm

#1169018
RE: Linked Server in SSIS

saillu78 (5/13/2010)
Hi,
i have a ODBC linked server Created in my Sql server (the linked server Points to Progress DB).
How to make the Linked server as Source and Move the Whole...

May 18, 2010 at 11:46 am

#1169000
RE: progress Database to Sql Server

No, it is not possible.

May 18, 2010 at 11:37 am

#1168994
RE: whats the advantage of SSIS tool over other ETL Tool

Steve Cullen (5/18/2010)
We use Data Integrator because it does something we need that SSIS does not do. We get packed decimal from our data supplier and Integrator can read...

May 18, 2010 at 11:29 am

#1168986
RE: whats the advantage of SSIS tool over other ETL Tool

imani_technology (5/15/2010)
I'm an old SQL Server guy, so I agree with you guys. It's just that we've had some proof of concept tests, with me advocating SSIS. For...

May 18, 2010 at 10:52 am

#1168956

Viewing 15 posts - 346 through 360 (of 1,118 total)