1,163 reputation
723
bio website
location Minneapolis, MN
age 28
visits member for 2 years, 4 months
seen 2 days ago

I'm a database architect/administrator specializing in Business Intelligence out of MSP.


Nov
5
comment SSIS package error, can't find pre-compiled script
If you open the script and then choose build does it give you any errors?
Oct
29
comment Why is Excel File Opened Exclusively By Another?
@Fastidious what does the package look like? Do you have multiple connections to that file within the package?
Oct
29
comment Why is Excel File Opened Exclusively By Another?
To completely rule out the idea that someone else has the file open. Try making a copy of the file. Then connecting to that copy and see if it works.
Oct
29
comment Char in select why
I'd prefer if you gave an example that didn't use pre Ansi-92 join syntax.
Oct
28
awarded  Notable Question
Oct
7
comment How do I Continue After a Failure in SSIS
That'll do fine just fine.
Sep
24
awarded  Autobiographer
Sep
18
comment Can't see some stored procedures in sys.procedures
@WayneFitz don't beat yourself up too hard there guy.
Sep
18
comment Can't see some stored procedures in sys.procedures
I wish I could Upvote Shawn for that edit. You sir are a saint.
Sep
18
comment Can't see some stored procedures in sys.procedures
I agree with @billinkc I think you may be overcomplicating this problem.
Sep
16
comment Encoding Debug UTF8 & Latin 1
Methinks you need to declare those strings like so. N'ForeignGibberish' Otherwise it doesn't assume it's unicode.
Sep
9
awarded  Nice Answer
Sep
9
comment SQL import data when both source and destination has data and identity column
Once you select the table just edit the column mappings.
Sep
8
comment SQL import data when both source and destination has data and identity column
If I can't see the query or the mappings I'm not really sure what else I can do to help you?
Sep
8
comment SQL import data when both source and destination has data and identity column
Can you post the query?
Sep
8
comment SQL import data when both source and destination has data and identity column
Make sure your column mappings are set right and that your source and destination have the same data types.
Sep
8
answered SQL import data when both source and destination has data and identity column
Sep
8
comment SQL import data when both source and destination has data and identity column
Why don't you just exclude that column if it's an Identity value that isn't referenced elsewhere?
Sep
8
comment SQL import data when both source and destination has data and identity column
"Violation of PRIMARY KEY constraint 'PK_Misc_Data' This seems to be your problem. You're inserting dupes. The duplicate key value is (1). you seems to already have an identity value of 1 in your destination table.
Aug
31
awarded  Popular Question