August 8, 2013 at 2:57 pm
I just started using SQL Server 2012 but have used 2000, 2005 and 2008 and have always used the import wizard to import Excel files. The "run immediately" option is disabled on the wizard so my only option is to save the import as an SSIS package. I do a lot of ad-hoc imports and don't really want to save any import as a package unless I will continually use it. My questions is how do you enable the "run immediately" option on the wizard? Thanks.
August 8, 2013 at 3:01 pm
Didn't you get any warning or error when you went through the wizard.
I remember the wizard disabling the run immediately when there was some sort of issue the wizard couldn't resolve, so you had to save the SSIS package and edit it.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 8, 2013 at 3:13 pm
I did get some warning while mapping but it used global types and the table turned out okay in SQL after I ran the package. I don't want to rerun the package because I'm picking up different named files with same format. I have had imports with the same situation before but I have never had the run immediately function disabled, I would assume it just would not run period if there was a problem.
August 8, 2013 at 4:05 pm
Found out the problem. Should have looked at the warning more closely. Thanks.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply