Thanks, Lynn. I will try to follow the article's recommendations.

--create table

CREATE TABLE [dbo].[ACADEMICCALENDAR](

[ACADEMIC_YEAR] [varchar](4) NOT NULL,

[ACADEMIC_TERM] [varchar](10) NOT NULL,

[ACADEMIC_SESSION] [varchar](10) NOT NULL,

[START_DATE] [datetime] NULL,

[END_DATE] [datetime] NULL

CONSTRAINT [ACACALENDAR_PK] PRIMARY KEY...

I really appreciate these helpful videos. I'm having some technical difficulty, though. I can only see about 2/3 of the screen while viewing the video. (I can't see the right-hand...

Thanks, Bob! That's exactly what I needed! 😀

This is going be a stupid question, I'm sure, but why would you use Open Row Set as opposed to just setting up a linked server and using the 4-part...

Please forgive me if my question is completely idiotic. I've been running SQL Server 2005 for nearly a year now and I've used BIDS to develop SSIS packages, etc... I...

Leju Geevarghese (1/27/2009)

---

please login as the user that starts the sql agent and run the exe or the bat file manully to store the key in the cache. So next...

I'm a bit confused about why my TLog backups aren't freeing up the space in the log files. My TLogs grow to mammoth proportions once I run my db maintenance...

Eureka! I finally found my problem. Would you believe that you can't run a .bat with a UNC path? This is a big pain in the butt because if I...

Ok, so I wrapped the whole thing in a .bat and set it up as an "Execute Process Task" in SSIS. If I run it from BIDS, it works. If...

Lynn,

You're right. My problem was that I developed the package in BIDS and saved it using the "encrypt sensitive data with user key." Then when I imported it back in,...

Everyone,

Thank you for your hints. I'm still having trouble. I logged onto the server under the SQL Server agent account and ran psftp from the command line prompt, answered Y...

I'm having this same problem. It runs fine from BIDS or even directly from SSMS when connected to Integration Services on the server. However, when I schedule it, it just...

I figured out my own answer! (for once--ha!) I added a cd line in my bat file to change to the directory I wanted first. Then the mput worked fine.

Can anybody tell me the correct syntax for mput to put in a directory beneath the root? I can get it to work with put one file at a time,...

Thank you so much, Wayne! That worked beautifully. I really appreciate your help!

Do you have any idea how to keep the PSFTP piece from opening up the command line window...