Re: Trying to get a SSIS Import wizard package to actually schedule and work.
- From: v-adamqu@xxxxxxxxxxxxxxxxxxxx (Adams Qu [MSFT])
- Date: Fri, 21 Dec 2007 13:58:40 GMT
Dear Frank,
Glad to hear from you.
If you need my further assistance, please do not hesitate to post back. It
is always my pleasure to be of assistance.
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
| References: <d7Q9j.25029$4V6.5475@xxxxxxxxxxxxxxxxxxxxxxxxxx>
<zzCvDIhQIHA.8164@xxxxxxxxxxxxxxxxxxxxxx>
<Xo9aj.264$6%.210@xxxxxxxxxxxxxxxxxxxx>
<NZIaDg6QIHA.5204@xxxxxxxxxxxxxxxxxxxxxx>
| Subject: Re: Trying to get a SSIS Import wizard package to actually
schedule and work.
| Lines: 326
| 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: <ymPaj.619$lo5.343@xxxxxxxxxxxxxxxxxxxxxxxxxx>
| NNTP-Posting-Host: 165.152.63.227
| X-Complaints-To: abuse@xxxxxxxxxxx
| X-Trace: newssvr19.news.prodigy.net 1198244382 ST000 165.152.63.227 (Fri,
21 Dec 2007 08:39:42 EST)
| NNTP-Posting-Date: Fri, 21 Dec 2007 08:39:42 EST
| Organization: AT&T http://yahoo.sbc.com
| X-UserInfo1:
SCSYQN_@FS@KRV@YJZHJOFXBWR\HPCTL@XT^OBPLAH[\RZ]CDVW[AKK[J\]^HVKHG^EWZHBLO^[\
NH_AZFWGN^\DHNVMX_DHHX[FSQKBOTS@@BP^]C@RHS_AGDDC[AJM_T[GZNRNZAY]GNCPBDYKOLK^
_CZFWPGHZIXW@C[AFKBBQS@E@DAZ]VDFUNTQQ]FN
| Date: Fri, 21 Dec 2007 07:39:41 -0600
| 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
!newssvr19.news.prodigy.net.POSTED!e51d285f!not-for-mail
| Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.sqlserver.dts:4258
| X-Tomcat-NG: microsoft.public.sqlserver.dts
|
| Thank you, I will give those a try...
|
|
|
|
| "Adams Qu [MSFT]" <v-adamqu@xxxxxxxxxxxxxxxxxxxx> wrote in message
| news:NZIaDg6QIHA.5204@xxxxxxxxxxxxxxxxxxxxxxxxx
| > Dear Frank,
| >
| > Thank you for posting back.
| >
| > First of all, we are sorry for the inconvenience this has brought to
you.
| > I
| > would like to explain that we are allowed to re-use the SSIS package
| > created by Import/Export Wizard. However, we need to ensure that the
temp
| > files initially created by this package exit on the system. These
| > temporary
| > files are responsible for the functions of Connection Manger of running
| > SSIS package.
| >
| > Thus, if you prefer to re-use the package saved from "Import/Export
| > Wizard", we need to backup all the tmp files created by this package to
| > prevent them from being unexpectedly deleted.
| >
| > In addition, you can also attempt to use the "Transfer SQL Server
Objects
| > Task" in SQL Server Business Intelligence Development Studio (Method
One
| > in
| > my previous post). Please be assured that this task also does not
require
| > the development skill. We use this task to transfer the SQL Server
Objects
| > by editing its properties directly. For your reference, I have included
| > the
| > article which contains the detail information about "Transfer SQL Server
| > Objects Task" for your reference.
| >
| > Transfer SQL Server Objects Task
| > http://msdn2.microsoft.com/en-us/library/ms142159.aspx
| >
| > Copy SQL Server Objects Task
| > http://msdn2.microsoft.com/en-us/library/aa933510(SQL.80).aspx
| >
| > I also understand that you have a lot of users who create 2000 DTS
| > packages. I also would like to explain that after installing Run-time
| > Support for SQL Server 2000 DTS Packages, we are still able to run the
SQL
| > Server 2000 DTS on the SQL Server 2005 SSIS via the " dtsrun.exe" from
| > command-line or "Execute DTS 2000 Package Task" from Integration
Services
| > Packages. The following article should be helpful:
| >
| > SQL Server 2005 Integration Services Backward Compatibility
| > http://msdn2.microsoft.com/en-us/library/ms143706.aspx
| >
| > At the same time, I also would like to share with the following relevant
| > resources for your further reference:
| >
| > Additional Reference
| > =========================
| > Reusing Package Objects
| > http://msdn2.microsoft.com/en-us/library/ms345172.aspx
| >
| > SQL Server 2005 Webcasts
| > http://msdn2.microsoft.com/en-us/sqlserver/aa336323.aspx
| >
| > Please don't hesitate to let me know if you have any further question or
| > needs my further assistance.
| >
| > 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
| > | References: <d7Q9j.25029$4V6.5475@xxxxxxxxxxxxxxxxxxxxxxxxxx>
| > <zzCvDIhQIHA.8164@xxxxxxxxxxxxxxxxxxxxxx>
| > | Subject: Re: Trying to get a SSIS Import wizard package to actually
| > schedule and work.
| > | Lines: 169
| > | 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: <Xo9aj.264$6%.210@xxxxxxxxxxxxxxxxxxxx>
| > | NNTP-Posting-Host: 165.152.63.227
| > | X-Complaints-To: abuse@xxxxxxxxxxx
| > | X-Trace: nlpi061.nbdc.sbc.com 1198072503 ST000 165.152.63.227 (Wed, 19
| > Dec 2007 08:55:03 EST)
| > | NNTP-Posting-Date: Wed, 19 Dec 2007 08:55:03 EST
| > | Organization: AT&T http://yahoo.sbc.com
| > | X-UserInfo1:
| >
TSU[@I_AO@UQBWXYAZJD]_\@VR]^@B@MCPWZKB]MPXH@ETUCCNSKQFCY@TXDX_WHSVB]ZEJLSNY\
| >
^J[CUVSA_QLFC^RQHUPH[P[NRWCCMLSNPOD_ESALHUK@TDFUZHBLJ\XGKL^NXA\EVHSP[D_C^B_^
| > JCX^W]CHBAX]POG@SSAZQ\LE[DCNMUPG_VSC@VJM
| > | Date: Wed, 19 Dec 2007 07:54:59 -0600
| > | 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
| > !nlpi061.nbdc.sbc.com.POSTED!e51d285f!not-for-mail
| > | Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.sqlserver.dts:4233
| > | X-Tomcat-NG: microsoft.public.sqlserver.dts
| > |
| > | Thanks you for your response...
| > | I was unaware that the Import/Export wizard pkgs was to perform the
| > tasks
| > | only once.
| > | It allows you to save it as did DTS wizard. The assumption is that you
| > can
| > | re-use it.
| > | This is inconsistent with SQL Server 2000 DTS. So I had no way of
| > knowing
| > -
| > | thank you.
| > |
| > | I will try Method 2, simply because I have no time to become a
| > developer.
| > | We have a lot of regular users who create 2000 DTS pkgs now, this is
| > going
| > | to be a nightmare.
| > |
| > |
| > |
| > |
| > | "Adams Qu [MSFT]" <v-adamqu@xxxxxxxxxxxxxxxxxxxx> wrote in message
| > | news:zzCvDIhQIHA.8164@xxxxxxxxxxxxxxxxxxxxxxxxx
| > | > 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
| > | > |
| > | > |
| > | > |
| > | > |
| > | > |
| > | >
| > |
| > |
| > |
| >
|
|
|
.
- References:
- Trying to get a SSIS Import wizard package to actually schedule and work.
- From: frankm
- RE: Trying to get a SSIS Import wizard package to actually schedule and work.
- From: Adams Qu [MSFT]
- Re: Trying to get a SSIS Import wizard package to actually schedule and work.
- From: frankm
- Re: Trying to get a SSIS Import wizard package to actually schedule and work.
- From: Adams Qu [MSFT]
- Re: Trying to get a SSIS Import wizard package to actually schedule and work.
- From: frankm
- Trying to get a SSIS Import wizard package to actually schedule and work.
- Prev by Date: Re: Trying to get a SSIS Import wizard package to actually schedule and work.
- Next by Date: Re: Syntax help
- Previous by thread: Re: Trying to get a SSIS Import wizard package to actually schedule and work.
- Next by thread: How to Push a file with FTP task to another server?
- Index(es):
Relevant Pages
|
