RE: Trying to get a SSIS Import wizard package to actually schedule and work.

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Dear Frank,

Thank you for posting here.

Based on my experience and research, I would like to explain that when
using the wizard to build the package, while saving or executing it at the
first time, there are some *.tmp files that will stored under
%USERPROFILE%\Local Settings\Temp folder and these *.tmp files are
necessary during the execution of the package. If any of them are corrupt
or missing, we may experience the behavior you have experienced.

To workaround/resolve the above issue, there are two possible methods:

Method One
------------------
1) As you know, the Import/Export Wizard is for you to perform the tasks
once. To reuse the package and easily deploy the package to other SQL
servers, I suggest that you develop the package in BIDS (SQL Server
Business Intelligence Development Studio). With the written package, it is
easily deployed / reused on other servers. Therefore, I suggest that you
create the package manually to transfer objects between databases directly
in BIDS by using "Transfer SQL Server Objects Task"

Method Two
------------------
2) If you prefer to use the package saved from "Import/Export Wizard" and
reuse it, we have to also take a copy of all generated *.tmp files under
%USERPROFILE%\Local Settings\Temp folder. Whenever you execute the package
again, check the "Connection Manager" part in "Execute Package Utility" and
note down the path/file information recorded into the package. Then, copy
all originally saved *.tmp files to the expected folder and run the
package. Or, we can also change the path/file information to the new one in
the "Connection Manager" part, where stores these *.temp files.

According to above methods, we recommend using the first method to rebuild
the SSIS package via BIDS ->"Transfer SQL Server Objects Task" to see if it
can resolve our issue.

If the issue persists, please help me to capture a screenshot when the
package fails to be executed:

Screenshot
=========================
1. Please press the Print Screen key (PrtScn) on your keyboard.
2. Click Start, click Run, type MSPAINT, and click OK.
3. In Paint, click Paste under the Edit Menu, click Save under the File
menu, type a file name for the snap shot, choose JPEG as "Save as type",
click "Desktop" on the left pane, and click Save.
4. Please find the screenshot on the Desktop and send it as an attachment
to: v-adamqu@xxxxxxxxxxxxx

If anything is unclear in my post, please don't hesitate to let me know and
I will be glad to help.

Have a nice day!

Best regards,

Adams Qu
MCSE, MCDBA, MCTS
Microsoft Online Support

Microsoft Global Technical Support Center

Get Secure! - www.microsoft.com/security
=====================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------
| From: "frankm" <frankm@xxxxxxxxxxxxxxxx>
| Newsgroups: microsoft.public.sqlserver.dts
| Subject: Trying to get a SSIS Import wizard package to actually schedule
and work.
| Lines: 34
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
| X-RFC2646: Format=Flowed; Original
| Message-ID: <d7Q9j.25029$4V6.5475@xxxxxxxxxxxxxxxxxxxxxxxxxx>
| NNTP-Posting-Host: 165.152.63.227
| X-Complaints-To: abuse@xxxxxxxxxxx
| X-Trace: newssvr14.news.prodigy.net 1197985353 ST000 165.152.63.227 (Tue,
18 Dec 2007 08:42:33 EST)
| NNTP-Posting-Date: Tue, 18 Dec 2007 08:42:33 EST
| Organization: SBC http://yahoo.sbc.com
| X-UserInfo1:
[[PAPDCAO@UQBWXYAZJD]_\@VR]^@B@MCPWZKB]MPXHTEPIB_NVUAH_[BL[\IRKIANGGJBFNJF_D
OLSCENSY^U@FRFUEXR@KFXYDBPWBCDQJA@X_DCBHXR[C@\EOKCJLED_SZ@RMWYXYWE_P@\\GOIW^
@SYFFSWHFIXMADO@^[ADPRPETLBJ]RDGENSKQQZN
| Date: Tue, 18 Dec 2007 13:42:33 GMT
| Path:
TK2MSFTNGHUB02.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTFEEDS02.phx.gbl!newsfeed0
0.sul.t-online.de!t-online.de!newshub.sdsu.edu!newscon04.news.prodigy.net!pr
odigy.net!newsdst01.news.prodigy.net!prodigy.com!postmaster.news.prodigy.com
!newssvr14.news.prodigy.net.POSTED!e51d285f!not-for-mail
| Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.sqlserver.dts:4223
| X-Tomcat-NG: microsoft.public.sqlserver.dts
|
| Sorry in advance for the frustrated tone.......
|
| -Created an straight up Wizard Import of data from one system / database
to
| another.
| -Figured out the scheduling a SSIS pkg thing.
| -Was getting encryption errors - found I needed Server Storage.
| -Figured out that I had to "COPY xxxx AS'
| -Was actually able to run the packages manually from the job. woohoo!
| -Scheduled jobs to run - running sa and or service account etc.
| -Come in Monday to find that they have been failing over the weekend.
| -Then got the fact that it couldn't find a tmp file in _MY_ home directory
| (why it would that is incomprehensible).
| -Tried to create a common folder, am now getting access denied no matter
how
| many rights I give to how may logins for any level of the directory or
| drive.
| -Kinda looks like a temporal key file that expires, goes away or is
deleted
| on exit.
| -Now I am back to - can't run it manually or schedule it to run.
|
| Can anyone help me???????????????
| I'm an admin and a dba - not a developer.
|
| Just ordered 2 books on SSIS - hope someone gets their pockets lined from
| the $70 I just shelled out.
|
| Does anyone think this is insane? Something that I could do in 10-15
minutes
| in DTS is now running into 3 days and I still haven't gotten it running.
|
|
| frankm
|
|
|
|
|

.

Relevant Pages