Hi, that's really odd then. No sum shows up. Only Group By, Count, and Count Distinct show. Does sorting it make the sum show?

Thanks,

Strick

Hi,

Actually, SSIS can handle this very well if you include a script task in your process. If you are familiar with writing a bit of VB.net code you can...

There actually is a padleft and padright property in vb.net that's great. So for example:

Dim MyValue as string = "test"

MyValue = MyValue.ToString.Padleft(5,"0")

will keep padding the value to a field...

No, it just times out in SSIS. The exact same statement will run in Mgmt Studio

Hi, Yes the test connection works fine. I can't remove the SET FMTONLY OFF because what this does is return the column schema to the meta data. The...

Hmmm interesting. I'll try that when i get to work.

Thanks,

Strick

Its empty. My first control flow task, a script task builds strSQL. THen then next task, the data flow uses it.

Thanks

Hi, thanks for your response. Unfortunately that didn't work. What's even weirder is that I'm doing something similiar with another package I did a while ago and the...

Hi,

Yes its an int datatype. I'll try that thanks!

Strick

And to add... That is really bad that SSIS won't let you connect to a SQL database file but you can connect to access dbs and flat files.

Strick

Thanks, I figured as much... kinda sucks.

So out of curiosity, if this were an ASP.NET app with the .mdf in its data directory and I wanted to have...

Hi,

Damn I hate when it's small stuff..lol. Thanks for your help Michael. It wasn't the data type, but your mention on case sensitivity made a little light go...

Great thanks!

Strick

Hi,

I just checked another package that I'm doing the exact same thing in and it works just fine! So now I'm really lost as to what I'm doing wrong

Here...

I do have SQL 2005 as a backend, but that shouldn't matter because the package is doing the work. The code should just fire the package. Hmmm, does...