Thanks, but we were able to accomplish this via Zappysys. Their component wasn't that expensive and works well for our needs. WD still recommends the SFTP download and upload method.

Thanks Phil ! Pretty close to what I was expecting, just updating it after allocations run to take care of the .001's.

I would say the first sql results splits are right and it should sum to 149.99 and yes I would like them to round and the bullet proof method is...

Well Yes you could, seeing if someone has script that I could reuse. I'm not proficient in C# or VB.Net.

Half the scripts online don't work or do a good job...

Hi,

I'm using SSIS, but I'm also importing a csv file that the users prepare and then do a automation to export a much reduced, automatically functionally allocated file after...

Thanks Jeff, really helpful !!!

Hi Jeff,

I mean my code is working fine, but I would like to learn if there are better ways to do this without cursors in 2008. Let me know if...

Hi Jeff,

I have modified the original script. Here's the entire script (DDL + Cursor Script)

IF OBJECT_ID (N'dbo.Account_Tagging', N'U') IS NOT NULL

AND EXISTS(SELECT * from dbo.Account_Tagging)

drop table Account_Tagging

BEGIN

CREATE TABLE...

Thanks Guys. I was trying to avoid cursors and see if there was a faster solution. I completely detest cursors :), but I guess I had no option since it's...

BIDS 2008.

Hi,

I have figured it out. You need to install VS tools seperately and BIDS is no longer part of the 2014 package. Not sure why Microsoft didn't just include it...

Department would be prefixed in this case.

Thanks All for taking time. Was using substring on charindex, let me know if there are better solutions.

Yes sorry i didn't reply back to this thread earlier.

The solution is to create a new connection but not uncheck the extra column in the flat file source.

Thanks,

V

I'm in the data flow task.. I'll write a sql task in the main script and try it out.

Hi Jeff,

Looks like a sql statement. What data flow transformation in SSIS would I use for this ?

Thanks,

V