Derived column not processing any records

Hi,

I have built a package in which i use a derived column to create a new set of columns and then pass the same to another target transformation.

The issue now what I am facing is, the re are certain number of records coming from source(16 rows) and gets processed before the Derived Column transformation, but after that, no records gets processed after the derived column transformation.

The package status shows as Success, but there is no records being written in the target table.

Any idea what could be the issue here?

Thanks,

Manish

Have you used data viewers on the data flow to see why records are not "passing" through? The records HAVE to go through the derived column -- it can't stop them.

Are you positive the records are not coming out of the derived column transformation?|||

Are no records being written to your destination, or you're just missing the derived values?

If the latter, I'd also check your column mappings in your destination (or any transformations downstream of your Derived Column Trx and upstream of your destination) to make sure your new columns are mapped. This is particularly important if you added the Derived Column Trx later in the development of your data flow. The mappings won't automatically appear.

|||

Hi Phil,

Thanks for the response.

Yes, I have put data viewers before and after the derived column transformation. The data viewer before the transformation shows the 13 records being passed, but the data viewer after the transformation doesnt show up any record, it is blank. I have tried many option in the mapping, but no luck.

I am now re-creating the mapping to check if the issue persists.

THough, let me know if you can think of any other scenario which could help in resolving this.

Thanks,

Manish

|||

ManishSingh wrote:

Hi Phil,

Thanks for the response.

Yes, I have put data viewers before and after the derived column transformation. The data viewer before the transformation shows the 13 records being passed, but the data viewer after the transformation doesnt show up any record, it is blank. I have tried many option in the mapping, but no luck.

I am now re-creating the mapping to check if the issue persists.

THough, let me know if you can think of any other scenario which could help in resolving this.

Thanks,

Manish

What mapping? There are no mappings in the derived column transformation.|||By mapping I was referring to the package. I tried various options to delete transformation and add another etc in the package to check for the data flow|||

ManishSingh wrote:

By mapping I was referring to the package. I tried various options to delete transformation and add another etc in the package to check for the data flow

Make a copy of your package for this test.

Leave everything as is, but remove EVERYTHING AFTER the derived column transformation and add a row count transformation. Hook it up to the derived column transformation. This will be your new destination. You'll need to add a variable for the row counter, of course.

Run the package. What happens? Does the derived column pass all rows through now?|||

Phil,

Thanks for your response. I was out of office, so couldnt reply back.

I tried adding the row count as the destination after the derived column transformation, and it was running successfully. Then again, I removed the row count and added the transformation again, and it started working. I am not sure, what could be the issue, but now its running fine.

Thanks for all your help. Really appreciate it!!!!!!!!

sql

Derived column not processing any records

Hi,

I have built a package in which i use a derived column to create a new set of columns and then pass the same to another target transformation.

The issue now what I am facing is, the re are certain number of records coming from source(16 rows) and gets processed before the Derived Column transformation, but after that, no records gets processed after the derived column transformation.

The package status shows as Success, but there is no records being written in the target table.

Any idea what could be the issue here?

Thanks,

Manish

Have you used data viewers on the data flow to see why records are not "passing" through? The records HAVE to go through the derived column -- it can't stop them.

Are you positive the records are not coming out of the derived column transformation?|||

Are no records being written to your destination, or you're just missing the derived values?

If the latter, I'd also check your column mappings in your destination (or any transformations downstream of your Derived Column Trx and upstream of your destination) to make sure your new columns are mapped. This is particularly important if you added the Derived Column Trx later in the development of your data flow. The mappings won't automatically appear.

|||

Hi Phil,

Thanks for the response.

Yes, I have put data viewers before and after the derived column transformation. The data viewer before the transformation shows the 13 records being passed, but the data viewer after the transformation doesnt show up any record, it is blank. I have tried many option in the mapping, but no luck.

I am now re-creating the mapping to check if the issue persists.

THough, let me know if you can think of any other scenario which could help in resolving this.

Thanks,

Manish

|||

ManishSingh wrote:

Hi Phil,

Thanks for the response.

Yes, I have put data viewers before and after the derived column transformation. The data viewer before the transformation shows the 13 records being passed, but the data viewer after the transformation doesnt show up any record, it is blank. I have tried many option in the mapping, but no luck.

I am now re-creating the mapping to check if the issue persists.

THough, let me know if you can think of any other scenario which could help in resolving this.

Thanks,

Manish

What mapping? There are no mappings in the derived column transformation.|||By mapping I was referring to the package. I tried various options to delete transformation and add another etc in the package to check for the data flow|||

ManishSingh wrote:

By mapping I was referring to the package. I tried various options to delete transformation and add another etc in the package to check for the data flow

Make a copy of your package for this test.

Leave everything as is, but remove EVERYTHING AFTER the derived column transformation and add a row count transformation. Hook it up to the derived column transformation. This will be your new destination. You'll need to add a variable for the row counter, of course.

Run the package. What happens? Does the derived column pass all rows through now?|||

Phil,

Thanks for your response. I was out of office, so couldnt reply back.

I tried adding the row count as the destination after the derived column transformation, and it was running successfully. Then again, I removed the row count and added the transformation again, and it started working. I am not sure, what could be the issue, but now its running fine.

Thanks for all your help. Really appreciate it!!!!!!!!

Deploying to subfolders from VS

I've got a report project with a few reports in I want in the root target directory. I also want to create several folders and put reports in those. The problem is I don't see any way to create a report folder in VS. I also don't see any way to pick the deployment path of a single reprot in VS. This makes me think I'll have to create a different Report Project in VS for each folder!! (this sucks). Does anyone have an idea or suggestion here?

Sorry, creating subfolder hierarchies directly from within a VS report project is currently not supported.

The closest you can get is to write a little application using the RS SOAP API to deploy your reports - you will then have full control over the folder hierarchy.

-- Robert

|||

This is highly unfortunate.

It makes deploying reports a real pain
because of the manual nature of having
to organize and overwrite older reports
(after deployment) that are existing in
sub-folders.

Can anyone provide some sources on
where to get started if one were to try
to write a custom deployment app?

|||

This link is to a tool that will give you some insight on how to deploy reports programmatically. It is not an automated process itself, but will give you an idea how it could be done.

http://www.sqldbatips.com/showarticle.asp?ID=62

I am creating a C# application that will use a small database for deployment data. With 3K+ remote servers, we have the same issue.

I originally thought I would use a method described elsewhere in the forum where you always deploy to one hidden folder and link all of your reports to their visible spots. I am not yet sure of the ramifications of that yet. If anyone has done deployments in this method, please let me know.

R

|||

Well, if you have any linked reports with landscape orientation, they will, more than likely, insist on printing portrait. Just something to consider. Another thread covers this:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=137986&SiteID=1

Even with the small glitches, SRS is a pleasure to work with.

|||So far the easiest way I've found to deal with this problem is to simply deploy all the reports in a project to the report server in a single place. Then, using the sql server management studio I can create folders and move reports into the proper location. It is not the best solution, but it works. It is a real hassle when updating reports. I just don't understand why microsoft did not make it possible to have report folders inside of visual studio. It would have taken an extra 10 minutes to program!
|||I agreed! Logical grouping is the most fundamental user function that you can find in all other MS or non MS products, but why not this one? We have 100+ reports, this has forced me to use some sort of special naming convention (Initiative - Category - subcategory - report name) for report name so that it's easier for me to find the reports in a flat list! Painful is to say the least...

Deploying to subfolders from VS

I've got a report project with a few reports in I want in the root target directory. I also want to create several folders and put reports in those. The problem is I don't see any way to create a report folder in VS. I also don't see any way to pick the deployment path of a single reprot in VS. This makes me think I'll have to create a different Report Project in VS for each folder!! (this sucks). Does anyone have an idea or suggestion here?

Sorry, creating subfolder hierarchies directly from within a VS report project is currently not supported.

The closest you can get is to write a little application using the RS SOAP API to deploy your reports - you will then have full control over the folder hierarchy.

-- Robert

|||

This is highly unfortunate.

It makes deploying reports a real pain
because of the manual nature of having
to organize and overwrite older reports
(after deployment) that are existing in
sub-folders.

Can anyone provide some sources on
where to get started if one were to try
to write a custom deployment app?

|||

This link is to a tool that will give you some insight on how to deploy reports programmatically. It is not an automated process itself, but will give you an idea how it could be done.

http://www.sqldbatips.com/showarticle.asp?ID=62

I am creating a C# application that will use a small database for deployment data. With 3K+ remote servers, we have the same issue.

I originally thought I would use a method described elsewhere in the forum where you always deploy to one hidden folder and link all of your reports to their visible spots. I am not yet sure of the ramifications of that yet. If anyone has done deployments in this method, please let me know.

R

|||

Well, if you have any linked reports with landscape orientation, they will, more than likely, insist on printing portrait. Just something to consider. Another thread covers this:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=137986&SiteID=1

Even with the small glitches, SRS is a pleasure to work with.

|||So far the easiest way I've found to deal with this problem is to simply deploy all the reports in a project to the report server in a single place. Then, using the sql server management studio I can create folders and move reports into the proper location. It is not the best solution, but it works. It is a real hassle when updating reports. I just don't understand why microsoft did not make it possible to have report folders inside of visual studio. It would have taken an extra 10 minutes to program!
|||I agreed! Logical grouping is the most fundamental user function that you can find in all other MS or non MS products, but why not this one? We have 100+ reports, this has forced me to use some sort of special naming convention (Initiative - Category - subcategory - report name) for report name so that it's easier for me to find the reports in a flat list! Painful is to say the least...

Deploying to subfolders from VS

I've got a report project with a few reports in I want in the root target directory. I also want to create several folders and put reports in those. The problem is I don't see any way to create a report folder in VS. I also don't see any way to pick the deployment path of a single reprot in VS. This makes me think I'll have to create a different Report Project in VS for each folder!! (this sucks). Does anyone have an idea or suggestion here?

Sorry, creating subfolder hierarchies directly from within a VS report project is currently not supported.

The closest you can get is to write a little application using the RS SOAP API to deploy your reports - you will then have full control over the folder hierarchy.

-- Robert

|||

This is highly unfortunate.

It makes deploying reports a real pain
because of the manual nature of having
to organize and overwrite older reports
(after deployment) that are existing in
sub-folders.

Can anyone provide some sources on
where to get started if one were to try
to write a custom deployment app?

|||

This link is to a tool that will give you some insight on how to deploy reports programmatically. It is not an automated process itself, but will give you an idea how it could be done.

http://www.sqldbatips.com/showarticle.asp?ID=62

I am creating a C# application that will use a small database for deployment data. With 3K+ remote servers, we have the same issue.

I originally thought I would use a method described elsewhere in the forum where you always deploy to one hidden folder and link all of your reports to their visible spots. I am not yet sure of the ramifications of that yet. If anyone has done deployments in this method, please let me know.

R

|||

Well, if you have any linked reports with landscape orientation, they will, more than likely, insist on printing portrait. Just something to consider. Another thread covers this:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=137986&SiteID=1

Even with the small glitches, SRS is a pleasure to work with.

|||So far the easiest way I've found to deal with this problem is to simply deploy all the reports in a project to the report server in a single place. Then, using the sql server management studio I can create folders and move reports into the proper location. It is not the best solution, but it works. It is a real hassle when updating reports. I just don't understand why microsoft did not make it possible to have report folders inside of visual studio. It would have taken an extra 10 minutes to program!
|||I agreed! Logical grouping is the most fundamental user function that you can find in all other MS or non MS products, but why not this one? We have 100+ reports, this has forced me to use some sort of special naming convention (Initiative - Category - subcategory - report name) for report name so that it's easier for me to find the reports in a flat list! Painful is to say the least...

Deploying Reports with WSS 3.0 integrated mode

Hi ,

I am trying to deploy reports through visual studio. In the Target server URL, specified the url of the report server as http://<localhost>:<portnumber>/reportserver/Shared Documents/. But
When i deploy it asks for username and password. when i provide them, again login screen appears. Finally deployment fails when i press cancel.

Did anybody face this kind of problem ?

Thanks & Regards,
Kiran Kumar

For deploying reports to a Report Server in SharePoint Integrated mode use the updated Report Designer that ships with SQL 2005 SP2 CTP3. Additionally, it is reco'd to deploy to the SharePoint Document Library with settings as follows:
TargetDataSourceFolder: http://<MyServer>/<mySharePointsite>/Shared Documents/
TargetReportFolder: http://<MyServer>/<mySharePointsite>/Shared Documents/
TargetServerURL: http://<MyServer>/<mySharePointsite>/

Hope this helps.

thanx,
Prash

|||

Can you also check for the following in the web.config file of the SharePoint web site:

- Do you see multiple entries looking like (?):

<location path="_vti_bin/ReportServer/ReportServiceAuthentication.asmx">
<system.web>
<authorization>
<allow users="*" />
</authorization>
</system.web>
</location>

There should be only one such entry for the ReportServiceAuthentication.asmx in the web.config. Please ensure there is only one such entry and retry deploying.

This is a bug that we are working on fixing for RTM.

deploying a database

Hi, do you know how to deploy a database (along with all the tables and data
in them etc.) from a development machine to the target machine? Can I just
copy the dabase file? (Assume the SQLServer application is already
installed on the target machine)
Thanks!Backup/restore,
Detach/Attach.
Either should work just fine
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
"Ido" <Ido@.discussions.microsoft.com> wrote in message
news:29EA6106-1D43-4B19-89F5-B2A438DA6B8F@.microsoft.com...
> Hi, do you know how to deploy a database (along with all the tables and
> data
> in them etc.) from a development machine to the target machine? Can I just
> copy the dabase file? (Assume the SQLServer application is already
> installed on the target machine)
> Thanks!|||http://vyaskn.tripod.com/moving_sql_server.htm Moving DBs
http://www.databasejournal.com/feat...cle.php/3379901 Moving
system DB's
http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465 Using WITH MOVE in a
Restore
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers
http://www.sqlservercentral.com/scr...sp?scriptid=599
Restoring a .mdf
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
for SQL Server
Andrew J. Kelly SQL MVP
"Ido" <Ido@.discussions.microsoft.com> wrote in message
news:29EA6106-1D43-4B19-89F5-B2A438DA6B8F@.microsoft.com...
> Hi, do you know how to deploy a database (along with all the tables and
> data
> in them etc.) from a development machine to the target machine? Can I just
> copy the dabase file? (Assume the SQLServer application is already
> installed on the target machine)
> Thanks!

deploying a database

Hi, do you know how to deploy a database (along with all the tables and data
in them etc.) from a development machine to the target machine? Can I just
copy the dabase file? (Assume the SQLServer application is already
installed on the target machine)
Thanks!
Backup/restore,
Detach/Attach.
Either should work just fine
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
"Ido" <Ido@.discussions.microsoft.com> wrote in message
news:29EA6106-1D43-4B19-89F5-B2A438DA6B8F@.microsoft.com...
> Hi, do you know how to deploy a database (along with all the tables and
> data
> in them etc.) from a development machine to the target machine? Can I just
> copy the dabase file? (Assume the SQLServer application is already
> installed on the target machine)
> Thanks!
|||http://vyaskn.tripod.com/moving_sql_server.htm Moving DBs
http://www.databasejournal.com/featu...le.php/3379901 Moving
system DB's
http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465 Using WITH MOVE in a
Restore
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers
http://www.sqlservercentral.com/scri...p?scriptid=599
Restoring a .mdf
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
for SQL Server
Andrew J. Kelly SQL MVP
"Ido" <Ido@.discussions.microsoft.com> wrote in message
news:29EA6106-1D43-4B19-89F5-B2A438DA6B8F@.microsoft.com...
> Hi, do you know how to deploy a database (along with all the tables and
> data
> in them etc.) from a development machine to the target machine? Can I just
> copy the dabase file? (Assume the SQLServer application is already
> installed on the target machine)
> Thanks!