Windows Firewall?

CEWII

I have a number of questions.

1. Are you using the Excel Source?

2. Have you set the datatypes of the source using the advanced editor?

3. What destination are you using OLEDB,...

So let me see if I got you right..

Your boss has you using software outside of the license, ie you don't have a license to use it commercially but you...

The part I like the best is that it paints a VERY clear picture and the comparison is VERY apples to apples.

CEWII

That was an amazing analogy G.. It is just perfect..

CEWII

I'd think it would be tough to work with these tables starting from empty, I don't think you could satisfy the FK.. Those FK's must have been added AFTER...

I would tend to agree with Jack.

If you can leverage SQL security it will make it a little easier..

CEWII

Do you have access to that path? What version of windows are you on? If Vista/2008/maybe 7 you probably need to run BIDS with the admin bit set....

Dude, drop the attitude, it will utterly prevent you from getting help. I am NOT the boss, but I have been here long enough and answered enough questions that...

You are welcome, sorry I didn't have a happier answer..

CEWII

See my other post on this same topic.

http://www.sqlservercentral.com/Forums/Topic818940-147-1.aspx

Please don't cross post.

CEWII

SQLCMD would be used to execute a sql script. Why wouldn't you just use an Execute SQL task? It is right there just for this reason..

CEWII

I don't think it will work at any compatibility level..

See this link:

http://msdn.microsoft.com/en-us/library/ms180099(SQL.90).aspx

CEWII

lmu92 (11/13/2009)

---

It's nothing more than that....

dreamthebest (11/13/2009)

---

Isn't there any way to create DDL triggers in system databases.

The idea of changing the default database is good but there are lots of logins and it...