Viewing 15 posts - 8,851 through 8,865 (of 9,725 total)
So far the only resolution I have found is to stick an Execute SQL Task right before my Data Flow, modify the Proc to stick the data in a real...
April 15, 2008 at 5:52 am
That's pretty much what I did the first time. Did it again and got the same error message. I'm wondering if it's a combination of the CTEs and...
April 15, 2008 at 4:17 am
I tried following your suggestion and got an immediate failure.
Error message is: Column "MyColumn" cannot be found at the datasource.
The OLE DB Source has ValidateExternalMetaData set to false. It...
April 14, 2008 at 1:10 pm
Michael, thanks for the correction. For some reason I really thought it wouldn't allow FULL OUTER.
Paul, really? Everything I've read said that partial & no caching is much...
April 14, 2008 at 10:56 am
BTW, Pretty sure the issue is the temp table myself since I tried redoing the proc with only the Temp table and not the CTE. Got the same "blank...
April 14, 2008 at 8:19 am
So, once I get everything properly set up, saving the ValidateExternalMetaData to False will allow the package to run?
I hadn't tried using a Proc stub, so of course I wasn't...
April 14, 2008 at 8:18 am
I've actually changed my two sources to two different dataflows that end up in the same destination staging table.
Unfortunately, while both sources do have crossover records, both sources also have...
April 14, 2008 at 6:44 am
John,
Actually, there wasn't much processing going on after the Split. And over the weekend, I just discovered what you're referring to (even though I didn't read your post until this...
April 14, 2008 at 5:24 am
Michael,
The problem is that I'm working on "staging the data" right now. I've already got everything in two separate SQL DBs (mainframe uploaded to SQL and the SQL...
April 11, 2008 at 9:12 am
Ah, well that would explain a lot.
Right now I'm still in Dev & Debug mode. But I guess it wouldn't hurt to disable everything but the container I'm currently...
April 11, 2008 at 8:41 am
I've found that the character mapping tranformation also works. But the question is, which one is better? Character Map or Derived Column?
For me, I think I'll drop the...
April 11, 2008 at 8:36 am
The best SSIS book I have found is the Microsoft SQL Server 2005 Integration Services book published by SAMS and written by Kirk Haselden. It explains all the tasks...
April 9, 2008 at 3:02 pm
Just an FYI, DTS is the old stuff. SSIS is the new stuff.
If you want to do this in SSIS, I recommend reading up on the following in Books...
April 9, 2008 at 2:55 pm
The reason I ask the question is all about basic programming concepts.
If you've done programming before (non-SQL), then you probably know all about the basic concepts of structure and covering...
April 9, 2008 at 2:46 pm
Chris,
Assuming your variable is a single value, try the following:
INSERT INTO DTSSTATUS (FIELD)
(SELECT ?)
And make sure the PARAMETER NAME value of the variable in the Parameter Mapping box...
April 9, 2008 at 2:40 pm
Viewing 15 posts - 8,851 through 8,865 (of 9,725 total)