Viewing 15 posts - 1 through 15 (of 74 total)
Well, I will provide my solution but like I've stated, it's VBA based but here it is:
Sub ProcessDataTransform()
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''
'''This...
May 21, 2013 at 12:13 pm
I decided to use VBA in Excel for each workbook who's data is being transferred into the csv. Thanks for the link and suggestions.
May 21, 2013 at 11:49 am
Hi Matthew,
I can't move the files after step 2 because the files aren't being referenced at this point. A csv is being connected to but not the Excel files....
May 21, 2013 at 10:10 am
You'll need a default connection even if you are setting the actual connection with an expression that evaluates at runtime.
Where do I set the default connection? I'm going to...
May 21, 2013 at 6:32 am
I only showed a small part of the For loop container. Check the new image out to see that I'm doing a fair bit in there and I'm still...
May 16, 2013 at 8:07 am
I've been working on a workaround for this. I've created individual connections for each CSV file. At a certain point in my package, and while using precedence constraints for...
May 15, 2013 at 8:46 am
If by format you mean the type of file then yes, they are all CSVs. If you mean the format in the csv then no, they all differ a...
May 15, 2013 at 8:43 am
Seriously? Darn! Now I'll have to make 11 different packages? Darn!
May 14, 2013 at 12:49 pm
Thank you very much for that. Most of that was copy/pasted from MS Word, which seems to be why the quotes are all weird. I've learned a lesson...
May 14, 2013 at 8:25 am
Thanks so much as this worked quite well. The expression didn't like User:: so I went with @Table_Number=="3790027" which was accepted.
November 29, 2012 at 9:54 am
Hi Evil,
Thank you very much for that. I actually went into the precedence constraints before posting here but I didn't know what to do there. Now I know...
November 29, 2012 at 9:39 am
Mordred (11/23/2012)
@ Jason, I would love to be able to do a bulk...
November 23, 2012 at 2:20 pm
@ learning_sql, I am going to give that a try and I thank you for that.
@ Jason, I would love to be able to do a bulk insert...
November 23, 2012 at 12:36 pm
Hi Jeff, I tried that yesterday and I still received truncation errors because SSIS is still trying to separate the columns where there are commas within the quotes. Thanks...
November 22, 2012 at 10:53 am
After all the Googling I've done today on this matter it seems like I am going to have to put each field value into a string, check it for a...
November 21, 2012 at 4:43 pm
Viewing 15 posts - 1 through 15 (of 74 total)