Is there a shortcut to actually paste "select * from " or whatever value you need? So all you would have to do is enter your shortcut then followed...

Ah, well that's what the problem is! hehe Thanks for the help anyway!

Will I need licensing for this? I've downloaded SSISPlus14.msi from the cozyroc site and that's what I've been using on my machine. Will I need some sort of license...

I restarted but it didn't work.

Do I need to install the CozyRoc software on the actual machine that's running the job? I develop the package on my...

I...

Yeah, that was my guess. I didn't want to mention it because I thought it might've been way off and I'd sound like a complete idiot. 😉 I...

I know this is an old thread, but I'm having the same issue. Is there any way I can specify which email credentials for the SSIS Send Mail Task...

It worked!! Thanks so much for the help!

I'm not worried about the NULL values. I have a Row Count that executes first and I can just edit the...

hehe So how do I do that exactly?

Declare @RowCountResult Int (or Varchar??)

Set @RowCountResult = 'SELECT Count(*) AS CountResult From Table Where name = 'Ryan''

I'm getting a syntax error.

Declare @body VARCHAR(255)

Set @body = 'This step generated ' + CAST(@RowCountResult AS varchar(10)) + ' records.'

EXEC msdb.dbo.sp_send_dbmail

@recipients=N'ryan@test.com',

@subject = 'Message Subject',

@profile_name ='Ryan_Test',

@body = @body

I'm guessing it's because I didn't declare/set @RowCountResult...

I have:

Set @body = 'This step generated ' + @RowCountResult + ' records.'

But I'm getting an error: "Must declare the scalar variable "@RowCountResult"

I searched it and the solutions don't...

OK, everything's working perfectly now. I just need to get Database mail to email me the file attachment. But that's for another day. hehe Thanks so much...

Freakin' genius! It worked, after I "un-commented" this line:

' CopyFile(FileSource, FileDestination)

hehe

I'm having trouble understanding how the Precedence Constraint Editor works though. I can sort of get...

OK, I figured out why it was saving to the parent directory.

FileDestination = FileIO.FileSystem.GetFileInfo(FileSource).DirectoryName & "\" & MonthName((Now().AddMonths(-1).Month)) & "_" & FileIO.FileSystem.GetFileInfo(FileSource).Name

I added the "\" between the DirectoryName and...

Um..so yeah...it's working...except the new file is located in the directory above, not the same directory. Hmm...